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_ALL_ASSIGNMENTS_F

Line 72: per_all_assignments_f to

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
76: the following classifications

Line 674: from per_all_assignments_f paf1,

670: -- 4915420
671:
672: select paf2.assignment_id
673: into l_temp_assignment_id
674: from per_all_assignments_f paf1,
675: per_all_assignments_f paf2,
676: hr_soft_coding_keyflex hsk
677: where paf1.assignment_id = p_assignment_id
678: and paf2.person_id = paf1.person_id

Line 675: per_all_assignments_f paf2,

671:
672: select paf2.assignment_id
673: into l_temp_assignment_id
674: from per_all_assignments_f paf1,
675: per_all_assignments_f paf2,
676: hr_soft_coding_keyflex hsk
677: where paf1.assignment_id = p_assignment_id
678: and paf2.person_id = paf1.person_id
679: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 685: from per_all_assignments_f paf3

681: and paf2.effective_end_date < p_session_date
682: and paf2.effective_end_date >= trunc(p_session_date,'YYYY')
683: and paf2.effective_end_date =
684: (select MAX(paf3.effective_end_date)
685: from per_all_assignments_f paf3
686: where paf3.person_id = paf1.person_id
687: and paf3.effective_end_date < p_session_date
688: )
689: and rownum=1;

Line 743: FROM per_all_assignments_f

739: FROM per_periods_of_service pps
740: WHERE date_start <= p_session_date
741: AND pps.period_of_service_id = (
742: SELECT DISTINCT(period_of_service_id)
743: FROM per_all_assignments_f
744: WHERE assignment_id = l_temp_assignment_id
745: AND assignment_type = 'E'
746: );
747:

Line 925: from per_all_assignments_f paf1,

921: -- 4915420
922:
923: select paf2.assignment_id
924: into l_temp_assignment_id
925: from per_all_assignments_f paf1,
926: per_all_assignments_f paf2,
927: hr_soft_coding_keyflex hsk
928: where paf1.assignment_id = p_assignment_id
929: and paf2.person_id = paf1.person_id

Line 926: per_all_assignments_f paf2,

922:
923: select paf2.assignment_id
924: into l_temp_assignment_id
925: from per_all_assignments_f paf1,
926: per_all_assignments_f paf2,
927: hr_soft_coding_keyflex hsk
928: where paf1.assignment_id = p_assignment_id
929: and paf2.person_id = paf1.person_id
930: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 936: from per_all_assignments_f paf3

932: and paf2.effective_end_date < p_session_date
933: and paf2.effective_end_date >= trunc(p_session_date,'YYYY')
934: and paf2.effective_end_date =
935: (select MAX(paf3.effective_end_date)
936: from per_all_assignments_f paf3
937: where paf3.person_id = paf1.person_id
938: and paf3.effective_end_date < p_session_date
939: )
940: and rownum=1;

Line 989: FROM per_all_assignments_f

985: FROM per_periods_of_service pps
986: WHERE date_start <= p_session_date
987: AND pps.period_of_service_id =
988: ( SELECT DISTINCT(period_of_service_id)
989: FROM per_all_assignments_f
990: WHERE assignment_id = l_temp_assignment_id
991: AND assignment_type = 'E');
992:
993: -- Set the year end date as the final process date if not specified