APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 481: l_retro_ele_type_id pay_element_types_f.retro_summ_ele_id%type;

477: p_assact_id in number default 0
478: )
479: is
480: --
481: l_retro_ele_type_id pay_element_types_f.retro_summ_ele_id%type;
482: --
483: begin
484: --
485: l_retro_ele_type_id := null;

Line 491: from pay_element_types_f pet1

487: if (p_retro_comp_id is null) then
488: --
489: select nvl(pet1.retro_summ_ele_id, pet1.element_type_id)
490: into l_retro_ele_type_id
491: from pay_element_types_f pet1
492: where pet1.element_type_id = p_element_type_id
493: and p_retro_eff_date between pet1.effective_start_date
494: and pet1.effective_end_date;
495: --

Line 1455: INDEX(pet pay_element_types_f_pk)

1451: p_ele_set_id in number
1452: )
1453: is
1454: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1455: INDEX(pet pay_element_types_f_pk)
1456: USE_NL(piv pet) */
1457: pee.element_entry_id,
1458: pee.source_start_date,
1459: pee.source_end_date,

Line 1473: pay_element_types_f pet,

1469: pee.assignment_id
1470: FROM pay_element_entries_f pee,
1471: pay_input_values_f piv,
1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,

Line 1474: pay_element_types_f pet1,

1470: FROM pay_element_entries_f pee,
1471: pay_input_values_f piv,
1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,
1478: pay_retro_defn_components prdc2,

Line 1558: INDEX(pet pay_element_types_f_pk)

1554:
1555: ----
1556: cursor get_proc_retro_rrv IS -- Added for 7335351
1557: SELECT /*+ INDEX(piv pay_input_values_f_pk)
1558: INDEX(pet pay_element_types_f_pk)
1559: USE_NL(piv pet) */
1560: pee.element_entry_id,
1561: pee.source_start_date,
1562: pee.source_end_date,

Line 1577: pay_element_types_f pet,

1573: pee.assignment_id
1574: FROM pay_element_entries_f pee,
1575: pay_input_values_f piv,
1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,

Line 1578: pay_element_types_f pet1,

1574: FROM pay_element_entries_f pee,
1575: pay_input_values_f piv,
1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,