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.SSP_SMP_SUPPORT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 722: from per_all_assignments_f

718: cursor csr_assignment(p_date date,
719: p_lsp date) is
720: select assignment_id,
721: payroll_id
722: from per_all_assignments_f
723: where person_id = p_person_id
724: and primary_flag = 'Y'
725: and assignment_type = 'E'
726: and least(p_date,p_lsp) between effective_start_date and effective_end_date;

Line 734: from per_all_assignments_f

730: p_asg_id number,
731: p_pay_id number) is
732: select min(effective_start_date),
733: max(nvl(effective_end_date,hr_general.end_of_time))
734: from per_all_assignments_f
735: where assignment_id = p_asg_id
736: and primary_flag = 'Y'
737: and assignment_type = 'E'
738: and payroll_id = p_pay_id;

Line 1141: per_all_assignments_f paf,

1137: /* Retrieve only those entries that will be retrieved by main SSP query */
1138: and peev3.element_entry_id in
1139: ( select peef1.element_entry_id
1140: from pay_element_entries_f peef1,
1141: per_all_assignments_f paf,
1142: per_all_people_f ppf,
1143: per_person_types ppt,
1144: per_periods_of_service pps
1145: where peef1.assignment_id = paf.assignment_id

Line 1268: from per_all_assignments_f paf,

1264: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1265: -- Retrieve only those entries that main SMP query will retrieve
1266: and exists
1267: ( select 1
1268: from per_all_assignments_f paf,
1269: per_all_people_f ppf,
1270: per_person_types ppt,
1271: per_periods_of_service pps
1272: where peef.assignment_id = paf.assignment_id

Line 1397: from per_all_assignments_f paf,

1393: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1394: -- Retrieve only those entries that main sap query will retrieve
1395: and exists
1396: ( select 1
1397: from per_all_assignments_f paf,
1398: per_all_people_f ppf,
1399: per_person_types ppt,
1400: per_periods_of_service pps
1401: where peef.assignment_id = paf.assignment_id

Line 1513: from per_all_assignments_f paf,

1509: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1510: -- Retrieve only those entries that main sppa query will retrieve
1511: and exists
1512: ( select 1
1513: from per_all_assignments_f paf,
1514: per_all_people_f ppf,
1515: per_person_types ppt,
1516: per_periods_of_service pps
1517: where peef.assignment_id = paf.assignment_id

Line 1628: from per_all_assignments_f paf,

1624: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1625: -- Retrieve only those entries that main SPPB query will retrieve
1626: and exists
1627: ( select 1
1628: from per_all_assignments_f paf,
1629: per_all_people_f ppf,
1630: per_person_types ppt,
1631: per_periods_of_service pps
1632: where peef.assignment_id = paf.assignment_id

Line 2442: per_all_assignments_f paf,

2438: /* Retrieve only those entries that will be retrieved by main SSP query */
2439: and peev3.element_entry_id in
2440: ( select peef1.element_entry_id
2441: from pay_element_entries_f peef1,
2442: per_all_assignments_f paf,
2443: per_all_people_f ppf,
2444: per_person_types ppt,
2445: per_periods_of_service pps
2446: where peef1.assignment_id = paf.assignment_id

Line 2569: from per_all_assignments_f paf,

2565: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2566: -- Retrieve only those entries that main SMP query will retrieve
2567: and exists
2568: ( select 1
2569: from per_all_assignments_f paf,
2570: per_all_people_f ppf,
2571: per_person_types ppt,
2572: per_periods_of_service pps
2573: where peef.assignment_id = paf.assignment_id

Line 2698: from per_all_assignments_f paf,

2694: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2695: -- Retrieve only those entries that main sap query will retrieve
2696: and exists
2697: ( select 1
2698: from per_all_assignments_f paf,
2699: per_all_people_f ppf,
2700: per_person_types ppt,
2701: per_periods_of_service pps
2702: where peef.assignment_id = paf.assignment_id

Line 2814: from per_all_assignments_f paf,

2810: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2811: -- Retrieve only those entries that main sppa query will retrieve
2812: and exists
2813: ( select 1
2814: from per_all_assignments_f paf,
2815: per_all_people_f ppf,
2816: per_person_types ppt,
2817: per_periods_of_service pps
2818: where peef.assignment_id = paf.assignment_id

Line 2929: from per_all_assignments_f paf,

2925: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2926: -- Retrieve only those entries that main SPPB query will retrieve
2927: and exists
2928: ( select 1
2929: from per_all_assignments_f paf,
2930: per_all_people_f ppf,
2931: per_person_types ppt,
2932: per_periods_of_service pps
2933: where peef.assignment_id = paf.assignment_id