eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_COST_ALLOCATION_API dependencies on PAY_COST_ALLOCATIONS_F

Line 393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;

389: p_segment26 ,p_segment27,p_segment28 ,p_segment29 ,p_segment30
390: );
391: --
392: l_combination_name varchar2(240);
393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;

Line 394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;

390: );
391: --
392: l_combination_name varchar2(240);
393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
398: --

Line 395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;

391: --
392: l_combination_name varchar2(240);
393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
398: --
399: cursor csr_cost_structure is

Line 396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;

392: l_combination_name varchar2(240);
393: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
394: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
395: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
396: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
397: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
398: --
399: cursor csr_cost_structure is
400: select pbg.cost_allocation_structure

Line 802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;

798: l_effective_date date;
799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
800: l_cost_allocation_keyflex_id number;
801: l_combination_name varchar2(240);
802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;

Line 803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;

799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
800: l_cost_allocation_keyflex_id number;
801: l_combination_name varchar2(240);
802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
807: --

Line 804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;

800: l_cost_allocation_keyflex_id number;
801: l_combination_name varchar2(240);
802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
807: --
808: cursor csr_cost_structure(p_bg_id number) is

Line 805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;

801: l_combination_name varchar2(240);
802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
804: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
805: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
806: l_concat_segs pay_cost_allocation_keyflex.concatenated_segments%TYPE;
807: --
808: cursor csr_cost_structure(p_bg_id number) is
809: select pbg.cost_allocation_structure

Line 816: from pay_cost_allocations_f pca

812: --
813: cursor csr_old_ccid is
814: select pca.cost_allocation_keyflex_id
815: , pca.business_group_id
816: from pay_cost_allocations_f pca
817: where pca.cost_allocation_id = p_cost_Allocation_id
818: and p_effective_date between pca.effective_start_date
819: and pca.effective_end_date;
820: --

Line 854: pay_cost_allocations_f pac

850: pca.segment28,
851: pca.segment29,
852: pca.segment30
853: from pay_cost_allocation_keyflex pca,
854: pay_cost_allocations_f pac
855: where pac.cost_allocation_id = p_cost_Allocation_id
856: and p_effective_date between pac.effective_start_date
857: and pac.effective_end_date
858: and pac.cost_allocation_keyflex_id = pca.cost_allocation_keyflex_id;

Line 1270: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;

1266: -- Declare cursors and local variables
1267: --
1268: l_proc varchar2(72) := g_package||'DELETE_COST_ALLOCATION';
1269: l_effective_date date;
1270: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
1271: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
1272: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
1273: --
1274: begin

Line 1271: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;

1267: --
1268: l_proc varchar2(72) := g_package||'DELETE_COST_ALLOCATION';
1269: l_effective_date date;
1270: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
1271: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
1272: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
1273: --
1274: begin
1275: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1272: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;

1268: l_proc varchar2(72) := g_package||'DELETE_COST_ALLOCATION';
1269: l_effective_date date;
1270: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
1271: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
1272: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
1273: --
1274: begin
1275: hr_utility.set_location('Entering:'|| l_proc, 10);
1276: --