DBA Data[Home] [Help]

APPS.SSP_SMP_SUPPORT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1114: pay_element_entries_f peef,

1110: select peev1.screen_entry_value
1111: from pay_element_entry_values_f peev1,
1112: pay_element_entry_values_f peev2,
1113: pay_input_values_f piv,
1114: pay_element_entries_f peef,
1115: pay_element_links_f pelf,
1116: pay_element_types_f petf
1117: where piv.input_value_id = peev1.input_value_id
1118: and peev1.element_entry_id = peev2.element_entry_id

Line 1140: from pay_element_entries_f peef1,

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

Line 1245: pay_element_entries_f peef,

1241: from pay_element_entry_values_f peev1,
1242: pay_element_entry_values_f peev2,
1243: pay_element_entry_values_f peev3,
1244: pay_input_values_f piv,
1245: pay_element_entries_f peef,
1246: pay_element_links_f pelf,
1247: pay_element_types_f petf
1248: where piv.input_value_id = peev1.input_value_id
1249: and peev1.element_entry_id = peev2.element_entry_id

Line 1375: pay_element_entries_f peef,

1371: select peev1.screen_entry_value
1372: from pay_element_entry_values_f peev1,
1373: pay_element_entry_values_f peev2,
1374: pay_input_values_f piv,
1375: pay_element_entries_f peef,
1376: pay_element_links_f pelf,
1377: pay_element_types_f petf
1378: where piv.input_value_id = peev1.input_value_id
1379: and peev1.element_entry_id = peev2.element_entry_id

Line 1491: pay_element_entries_f peef,

1487: select peev1.screen_entry_value
1488: from pay_element_entry_values_f peev1,
1489: pay_element_entry_values_f peev2,
1490: pay_input_values_f piv,
1491: pay_element_entries_f peef,
1492: pay_element_links_f pelf,
1493: pay_element_types_f petf
1494: where piv.input_value_id = peev1.input_value_id
1495: and peev1.element_entry_id = peev2.element_entry_id

Line 1606: pay_element_entries_f peef,

1602: select peev1.screen_entry_value
1603: from pay_element_entry_values_f peev1,
1604: pay_element_entry_values_f peev2,
1605: pay_input_values_f piv,
1606: pay_element_entries_f peef,
1607: pay_element_links_f pelf,
1608: pay_element_types_f petf
1609: where piv.input_value_id = peev1.input_value_id
1610: and peev1.element_entry_id = peev2.element_entry_id

Line 2415: pay_element_entries_f peef,

2411: select peev1.screen_entry_value
2412: from pay_element_entry_values_f peev1,
2413: pay_element_entry_values_f peev2,
2414: pay_input_values_f piv,
2415: pay_element_entries_f peef,
2416: pay_element_links_f pelf,
2417: pay_element_types_f petf
2418: where piv.input_value_id = peev1.input_value_id
2419: and peev1.element_entry_id = peev2.element_entry_id

Line 2441: from pay_element_entries_f peef1,

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

Line 2546: pay_element_entries_f peef,

2542: from pay_element_entry_values_f peev1,
2543: pay_element_entry_values_f peev2,
2544: pay_element_entry_values_f peev3,
2545: pay_input_values_f piv,
2546: pay_element_entries_f peef,
2547: pay_element_links_f pelf,
2548: pay_element_types_f petf
2549: where piv.input_value_id = peev1.input_value_id
2550: and peev1.element_entry_id = peev2.element_entry_id

Line 2676: pay_element_entries_f peef,

2672: select peev1.screen_entry_value
2673: from pay_element_entry_values_f peev1,
2674: pay_element_entry_values_f peev2,
2675: pay_input_values_f piv,
2676: pay_element_entries_f peef,
2677: pay_element_links_f pelf,
2678: pay_element_types_f petf
2679: where piv.input_value_id = peev1.input_value_id
2680: and peev1.element_entry_id = peev2.element_entry_id

Line 2792: pay_element_entries_f peef,

2788: select peev1.screen_entry_value
2789: from pay_element_entry_values_f peev1,
2790: pay_element_entry_values_f peev2,
2791: pay_input_values_f piv,
2792: pay_element_entries_f peef,
2793: pay_element_links_f pelf,
2794: pay_element_types_f petf
2795: where piv.input_value_id = peev1.input_value_id
2796: and peev1.element_entry_id = peev2.element_entry_id

Line 2907: pay_element_entries_f peef,

2903: select peev1.screen_entry_value
2904: from pay_element_entry_values_f peev1,
2905: pay_element_entry_values_f peev2,
2906: pay_input_values_f piv,
2907: pay_element_entries_f peef,
2908: pay_element_links_f pelf,
2909: pay_element_types_f petf
2910: where piv.input_value_id = peev1.input_value_id
2911: and peev1.element_entry_id = peev2.element_entry_id