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 677: from per_all_assignments_f

673: cursor csr_assignment(p_date date,
674: p_lsp date) is
675: select assignment_id,
676: payroll_id
677: from per_all_assignments_f
678: where person_id = p_person_id
679: and primary_flag = 'Y'
680: and assignment_type = 'E'
681: and least(p_date,p_lsp) between effective_start_date and effective_end_date;

Line 689: from per_all_assignments_f

685: p_asg_id number,
686: p_pay_id number) is
687: select min(effective_start_date),
688: max(nvl(effective_end_date,hr_general.end_of_time))
689: from per_all_assignments_f
690: where assignment_id = p_asg_id
691: and primary_flag = 'Y'
692: and assignment_type = 'E'
693: and payroll_id = p_pay_id;

Line 1088: per_all_assignments_f paf,

1084: /* Retrieve only those entries that will be retrieved by main SSP query */
1085: and peev3.element_entry_id in
1086: ( select peef1.element_entry_id
1087: from pay_element_entries_f peef1,
1088: per_all_assignments_f paf,
1089: per_all_people_f ppf,
1090: per_person_types ppt,
1091: per_periods_of_service pps
1092: where peef1.assignment_id = paf.assignment_id

Line 1215: from per_all_assignments_f paf,

1211: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1212: -- Retrieve only those entries that main SMP query will retrieve
1213: and exists
1214: ( select 1
1215: from per_all_assignments_f paf,
1216: per_all_people_f ppf,
1217: per_person_types ppt,
1218: per_periods_of_service pps
1219: where peef.assignment_id = paf.assignment_id

Line 1344: from per_all_assignments_f paf,

1340: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1341: -- Retrieve only those entries that main sap query will retrieve
1342: and exists
1343: ( select 1
1344: from per_all_assignments_f paf,
1345: per_all_people_f ppf,
1346: per_person_types ppt,
1347: per_periods_of_service pps
1348: where peef.assignment_id = paf.assignment_id

Line 1460: from per_all_assignments_f paf,

1456: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1457: -- Retrieve only those entries that main sppa query will retrieve
1458: and exists
1459: ( select 1
1460: from per_all_assignments_f paf,
1461: per_all_people_f ppf,
1462: per_person_types ppt,
1463: per_periods_of_service pps
1464: where peef.assignment_id = paf.assignment_id

Line 1575: from per_all_assignments_f paf,

1571: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
1572: -- Retrieve only those entries that main SPPB query will retrieve
1573: and exists
1574: ( select 1
1575: from per_all_assignments_f paf,
1576: per_all_people_f ppf,
1577: per_person_types ppt,
1578: per_periods_of_service pps
1579: where peef.assignment_id = paf.assignment_id

Line 2138: per_all_assignments_f paf,

2134: /* Retrieve only those entries that will be retrieved by main SSP query */
2135: and peev3.element_entry_id in
2136: ( select peef1.element_entry_id
2137: from pay_element_entries_f peef1,
2138: per_all_assignments_f paf,
2139: per_all_people_f ppf,
2140: per_person_types ppt,
2141: per_periods_of_service pps
2142: where peef1.assignment_id = paf.assignment_id

Line 2265: from per_all_assignments_f paf,

2261: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2262: -- Retrieve only those entries that main SMP query will retrieve
2263: and exists
2264: ( select 1
2265: from per_all_assignments_f paf,
2266: per_all_people_f ppf,
2267: per_person_types ppt,
2268: per_periods_of_service pps
2269: where peef.assignment_id = paf.assignment_id

Line 2394: from per_all_assignments_f paf,

2390: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2391: -- Retrieve only those entries that main sap query will retrieve
2392: and exists
2393: ( select 1
2394: from per_all_assignments_f paf,
2395: per_all_people_f ppf,
2396: per_person_types ppt,
2397: per_periods_of_service pps
2398: where peef.assignment_id = paf.assignment_id

Line 2510: from per_all_assignments_f paf,

2506: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2507: -- Retrieve only those entries that main sppa query will retrieve
2508: and exists
2509: ( select 1
2510: from per_all_assignments_f paf,
2511: per_all_people_f ppf,
2512: per_person_types ppt,
2513: per_periods_of_service pps
2514: where peef.assignment_id = paf.assignment_id

Line 2625: from per_all_assignments_f paf,

2621: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)
2622: -- Retrieve only those entries that main SPPB query will retrieve
2623: and exists
2624: ( select 1
2625: from per_all_assignments_f paf,
2626: per_all_people_f ppf,
2627: per_person_types ppt,
2628: per_periods_of_service pps
2629: where peef.assignment_id = paf.assignment_id