APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 463: l_retro_ele_type_id pay_element_types_f.retro_summ_ele_id%type;

459: p_business_group_id in number default null
460: )
461: is
462: --
463: l_retro_ele_type_id pay_element_types_f.retro_summ_ele_id%type;
464: --
465: begin
466: --
467: l_retro_ele_type_id := null;

Line 473: from pay_element_types_f pet1

469: if (p_retro_comp_id is null) then
470: --
471: select nvl(pet1.retro_summ_ele_id, pet1.element_type_id)
472: into l_retro_ele_type_id
473: from pay_element_types_f pet1
474: where pet1.element_type_id = p_element_type_id
475: and p_retro_eff_date between pet1.effective_start_date
476: and pet1.effective_end_date;
477: --

Line 1424: INDEX(pet pay_element_types_f_pk)

1420: p_ele_set_id in number
1421: )
1422: is
1423: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1424: INDEX(pet pay_element_types_f_pk)
1425: USE_NL(piv pet) */
1426: pee.element_entry_id,
1427: pee.source_start_date,
1428: pee.source_end_date,

Line 1442: pay_element_types_f pet,

1438: pee.assignment_id
1439: FROM pay_element_entries_f pee,
1440: pay_input_values_f piv,
1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,

Line 1443: pay_element_types_f pet1,

1439: FROM pay_element_entries_f pee,
1440: pay_input_values_f piv,
1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,
1447: pay_retro_defn_components prdc2,

Line 1527: INDEX(pet pay_element_types_f_pk)

1523:
1524: ----
1525: cursor get_proc_retro_rrv IS -- Added for 7335351
1526: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1527: INDEX(pet pay_element_types_f_pk)
1528: USE_NL(piv pet) */
1529: pee.element_entry_id,
1530: pee.source_start_date,
1531: pee.source_end_date,

Line 1544: pay_element_types_f pet,

1540: pee.assignment_id
1541: FROM pay_element_entries_f pee,
1542: pay_input_values_f piv,
1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,

Line 1545: pay_element_types_f pet1,

1541: FROM pay_element_entries_f pee,
1542: pay_input_values_f piv,
1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,