DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1061: pay_element_entries_f peef,

1057: select peev1.screen_entry_value
1058: from pay_element_entry_values_f peev1,
1059: pay_element_entry_values_f peev2,
1060: pay_input_values_f piv,
1061: pay_element_entries_f peef,
1062: pay_element_links_f pelf,
1063: pay_element_types_f petf
1064: where piv.input_value_id = peev1.input_value_id
1065: and peev1.element_entry_id = peev2.element_entry_id

Line 1087: from pay_element_entries_f peef1,

1083: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))
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

Line 1192: pay_element_entries_f peef,

1188: from pay_element_entry_values_f peev1,
1189: pay_element_entry_values_f peev2,
1190: pay_element_entry_values_f peev3,
1191: pay_input_values_f piv,
1192: pay_element_entries_f peef,
1193: pay_element_links_f pelf,
1194: pay_element_types_f petf
1195: where piv.input_value_id = peev1.input_value_id
1196: and peev1.element_entry_id = peev2.element_entry_id

Line 1322: pay_element_entries_f peef,

1318: select peev1.screen_entry_value
1319: from pay_element_entry_values_f peev1,
1320: pay_element_entry_values_f peev2,
1321: pay_input_values_f piv,
1322: pay_element_entries_f peef,
1323: pay_element_links_f pelf,
1324: pay_element_types_f petf
1325: where piv.input_value_id = peev1.input_value_id
1326: and peev1.element_entry_id = peev2.element_entry_id

Line 1438: pay_element_entries_f peef,

1434: select peev1.screen_entry_value
1435: from pay_element_entry_values_f peev1,
1436: pay_element_entry_values_f peev2,
1437: pay_input_values_f piv,
1438: pay_element_entries_f peef,
1439: pay_element_links_f pelf,
1440: pay_element_types_f petf
1441: where piv.input_value_id = peev1.input_value_id
1442: and peev1.element_entry_id = peev2.element_entry_id

Line 1553: pay_element_entries_f peef,

1549: select peev1.screen_entry_value
1550: from pay_element_entry_values_f peev1,
1551: pay_element_entry_values_f peev2,
1552: pay_input_values_f piv,
1553: pay_element_entries_f peef,
1554: pay_element_links_f pelf,
1555: pay_element_types_f petf
1556: where piv.input_value_id = peev1.input_value_id
1557: and peev1.element_entry_id = peev2.element_entry_id

Line 2111: pay_element_entries_f peef,

2107: select peev1.screen_entry_value
2108: from pay_element_entry_values_f peev1,
2109: pay_element_entry_values_f peev2,
2110: pay_input_values_f piv,
2111: pay_element_entries_f peef,
2112: pay_element_links_f pelf,
2113: pay_element_types_f petf
2114: where piv.input_value_id = peev1.input_value_id
2115: and peev1.element_entry_id = peev2.element_entry_id

Line 2137: from pay_element_entries_f peef1,

2133: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))
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

Line 2242: pay_element_entries_f peef,

2238: from pay_element_entry_values_f peev1,
2239: pay_element_entry_values_f peev2,
2240: pay_element_entry_values_f peev3,
2241: pay_input_values_f piv,
2242: pay_element_entries_f peef,
2243: pay_element_links_f pelf,
2244: pay_element_types_f petf
2245: where piv.input_value_id = peev1.input_value_id
2246: and peev1.element_entry_id = peev2.element_entry_id

Line 2372: pay_element_entries_f peef,

2368: select peev1.screen_entry_value
2369: from pay_element_entry_values_f peev1,
2370: pay_element_entry_values_f peev2,
2371: pay_input_values_f piv,
2372: pay_element_entries_f peef,
2373: pay_element_links_f pelf,
2374: pay_element_types_f petf
2375: where piv.input_value_id = peev1.input_value_id
2376: and peev1.element_entry_id = peev2.element_entry_id

Line 2488: pay_element_entries_f peef,

2484: select peev1.screen_entry_value
2485: from pay_element_entry_values_f peev1,
2486: pay_element_entry_values_f peev2,
2487: pay_input_values_f piv,
2488: pay_element_entries_f peef,
2489: pay_element_links_f pelf,
2490: pay_element_types_f petf
2491: where piv.input_value_id = peev1.input_value_id
2492: and peev1.element_entry_id = peev2.element_entry_id

Line 2603: pay_element_entries_f peef,

2599: select peev1.screen_entry_value
2600: from pay_element_entry_values_f peev1,
2601: pay_element_entry_values_f peev2,
2602: pay_input_values_f piv,
2603: pay_element_entries_f peef,
2604: pay_element_links_f pelf,
2605: pay_element_types_f petf
2606: where piv.input_value_id = peev1.input_value_id
2607: and peev1.element_entry_id = peev2.element_entry_id