APPS.GHR_CORR_CANC_SF52 dependencies on PAY_ELEMENT_LINKS_F

Line 1829: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt

1825: l_bus_group_id NUMBER;
1826:
1827: CURSOR c_element_name(p_element_link_id NUMBER) IS
1828: SELECT elt.element_name
1829: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt
1830: WHERE ell.ELEMENT_type_id = elt.element_type_id
1831: AND ell.element_link_id = p_element_link_id;
1832: --
1833: -- Created the following cursor to handle same day other pay actions.

Line 1836: FROM PAY_ELEMENT_LINKS_F ell,

1832: --
1833: -- Created the following cursor to handle same day other pay actions.
1834: CURSOR c_element_name1(p_element_entry_id NUMBER) IS
1835: SELECT elt.element_name
1836: FROM PAY_ELEMENT_LINKS_F ell,
1837: PAY_ELEMENT_TYPES_F elt,
1838: pay_element_entries_f ele
1839: WHERE ell.ELEMENT_type_id = elt.element_type_id
1840: AND ele.element_type_id = elt.element_type_id

Line 4114: PAY_ELEMENT_LINKS_F ELL,

4110: ,p_bg_id IN number)
4111: IS
4112: SELECT ELT.ELEMENT_NAME
4113: FROM PAY_ELEMENT_TYPES_F ELT,
4114: PAY_ELEMENT_LINKS_F ELL,
4115: PAY_ELEMENT_ENTRIES_F ELE
4116: WHERE TRUNC(cp_eff_date) BETWEEN ELT.EFFECTIVE_START_DATE
4117: AND ELT.EFFECTIVE_END_DATE
4118: AND TRUNC(cp_eff_date) BETWEEN ELL.EFFECTIVE_START_DATE

Line 5936: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee

5932: pet.effective_start_date,
5933: pet.effective_end_date,
5934: pet.processing_type
5935: from
5936: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee
5937: where pee.element_entry_id = cp_element_entry_id and
5938: pee.element_link_id = pel.element_link_id and
5939: pet.element_type_id = pel.element_type_id and
5940: cp_effective_start_date between pee.effective_start_date and pee.effective_end_date and