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_US_EMPLOYEE_BALANCES dependencies on PER_ASSIGNMENTS_F

Line 71: 13-Jan-2006 rpasumar 115.8 4915420 Changed per_assignments_f to

67: last standard process date
68: 17-Mar-2005 meshah 115.7 4039299 changed cursor
69: csr_element_assact_runs and changed
70: the exists clause.
71: 13-Jan-2006 rpasumar 115.8 4915420 Changed per_assignments_f to
72: per_all_assignments_f to
73: improve performance.
74: 23-Aug-2006 kvsankar 115.9 5460886 Added a new cursor
75: csr_element_assact_info_dedn for

Line 146: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;

142: l_last_process_date DATE;
143: l_date DATE;
144: l_ytd_date DATE;
145: l_qtd_date DATE ;
146: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;
147: l_dim_month varchar2(20);
148: l_dim_qtd varchar2(20);
149: l_dim_ytd varchar2(20);
150:

Line 610: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;

606: l_last_process_date DATE;
607: l_date DATE;
608: l_ytd_id number(9);
609: l_qtd_id number(9);
610: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;
611: l_function varchar2(9);
612:
613: BEGIN
614: l_function :='get_bal';

Line 628: from per_assignments_f paf,

624:
625: -- check to see if p_assignment_id exist as of l_date
626: select paf.assignment_id
627: into l_temp_assignment_id
628: from per_assignments_f paf,
629: hr_soft_coding_keyflex hsk
630: where paf.assignment_id = p_assignment_id
631: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
632: and p_session_date between paf.effective_start_date

Line 650: from per_assignments_f paf1,

646: hr_utility.set_location(l_package||l_function, 40);
647:
648: select paf2.assignment_id
649: into l_temp_assignment_id
650: from per_assignments_f paf1,
651: per_assignments_f paf2,
652: hr_soft_coding_keyflex hsk
653: where paf1.assignment_id = p_assignment_id
654: and paf2.person_id = paf1.person_id

Line 651: per_assignments_f paf2,

647:
648: select paf2.assignment_id
649: into l_temp_assignment_id
650: from per_assignments_f paf1,
651: per_assignments_f paf2,
652: hr_soft_coding_keyflex hsk
653: where paf1.assignment_id = p_assignment_id
654: and paf2.person_id = paf1.person_id
655: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 693: from per_assignments_f paf1,

689: and rownum=1;
690:
691: /* select paf2.assignment_id
692: into l_temp_assignment_id
693: from per_assignments_f paf1,
694: per_assignments_f paf2,
695: hr_soft_coding_keyflex hsk
696: where paf1.assignment_id = p_assignment_id
697: and paf2.person_id = paf1.person_id

Line 694: per_assignments_f paf2,

690:
691: /* select paf2.assignment_id
692: into l_temp_assignment_id
693: from per_assignments_f paf1,
694: per_assignments_f paf2,
695: hr_soft_coding_keyflex hsk
696: where paf1.assignment_id = p_assignment_id
697: and paf2.person_id = paf1.person_id
698: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 704: from per_assignments_f paf3

700: and paf2.effective_end_date < p_session_date
701: and paf2.effective_end_date >= trunc(p_session_date,'YYYY')
702: and paf2.effective_end_date =
703: (select MAX(paf3.effective_end_date)
704: from per_assignments_f paf3
705: where paf3.person_id = paf1.person_id
706: and paf3.effective_end_date < p_session_date
707: )
708: and rownum=1; */

Line 881: from per_assignments_f paf,

877: BEGIN
878: -- check to see if p_assignment_id exist as of l_date
879: select paf.assignment_id
880: into l_temp_assignment_id
881: from per_assignments_f paf,
882: hr_soft_coding_keyflex hsk
883: where paf.assignment_id = p_assignment_id
884: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
885: and p_session_date between paf.effective_start_date

Line 902: from per_assignments_f paf1,

898:
899:
900: select paf2.assignment_id
901: into l_temp_assignment_id
902: from per_assignments_f paf1,
903: per_assignments_f paf2,
904: hr_soft_coding_keyflex hsk
905: where paf1.assignment_id = p_assignment_id
906: and paf2.person_id = paf1.person_id

Line 903: per_assignments_f paf2,

899:
900: select paf2.assignment_id
901: into l_temp_assignment_id
902: from per_assignments_f paf1,
903: per_assignments_f paf2,
904: hr_soft_coding_keyflex hsk
905: where paf1.assignment_id = p_assignment_id
906: and paf2.person_id = paf1.person_id
907: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 944: from per_assignments_f paf1,

940: and rownum=1;
941:
942: /* select paf2.assignment_id
943: into l_temp_assignment_id
944: from per_assignments_f paf1,
945: per_assignments_f paf2,
946: hr_soft_coding_keyflex hsk
947: where paf1.assignment_id = p_assignment_id
948: and paf2.person_id = paf1.person_id

Line 945: per_assignments_f paf2,

941:
942: /* select paf2.assignment_id
943: into l_temp_assignment_id
944: from per_assignments_f paf1,
945: per_assignments_f paf2,
946: hr_soft_coding_keyflex hsk
947: where paf1.assignment_id = p_assignment_id
948: and paf2.person_id = paf1.person_id
949: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 955: from per_assignments_f paf3

951: and paf2.effective_end_date < p_session_date
952: and paf2.effective_end_date >= trunc(p_session_date,'YYYY')
953: and paf2.effective_end_date =
954: (select MAX(paf3.effective_end_date)
955: from per_assignments_f paf3
956: where paf3.person_id = paf1.person_id
957: and paf3.effective_end_date < p_session_date
958: )
959: and rownum=1; */