APPS.GHR_CORR_CANC_SF52 dependencies on PAY_ELEMENT_LINKS_F

Line 1656: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt

1652: l_bus_group_id NUMBER;
1653:
1654: CURSOR c_element_name(p_element_link_id NUMBER) IS
1655: SELECT elt.element_name
1656: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt
1657: WHERE ell.ELEMENT_type_id = elt.element_type_id
1658: AND ell.element_link_id = p_element_link_id;
1659: --
1660: -- Created the following cursor to handle same day other pay actions.

Line 1663: FROM PAY_ELEMENT_LINKS_F ell,

1659: --
1660: -- Created the following cursor to handle same day other pay actions.
1661: CURSOR c_element_name1(p_element_entry_id NUMBER) IS
1662: SELECT elt.element_name
1663: FROM PAY_ELEMENT_LINKS_F ell,
1664: PAY_ELEMENT_TYPES_F elt,
1665: pay_element_entries_f ele
1666: WHERE ell.ELEMENT_type_id = elt.element_type_id
1667: AND ele.element_type_id = elt.element_type_id

Line 3806: PAY_ELEMENT_LINKS_F ELL,

3802: ,p_bg_id IN number)
3803: IS
3804: SELECT ELT.ELEMENT_NAME
3805: FROM PAY_ELEMENT_TYPES_F ELT,
3806: PAY_ELEMENT_LINKS_F ELL,
3807: PAY_ELEMENT_ENTRIES_F ELE
3808: WHERE TRUNC(cp_eff_date) BETWEEN ELT.EFFECTIVE_START_DATE
3809: AND ELT.EFFECTIVE_END_DATE
3810: AND TRUNC(cp_eff_date) BETWEEN ELL.EFFECTIVE_START_DATE

Line 5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee

5581: pet.effective_start_date,
5582: pet.effective_end_date,
5583: pet.processing_type
5584: from
5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee
5586: where pee.element_entry_id = cp_element_entry_id and
5587: pee.element_link_id = pel.element_link_id and
5588: pet.element_type_id = pel.element_type_id and
5589: cp_effective_start_date between pee.effective_start_date and pee.effective_end_date and