APPS.GHR_CORR_CANC_SF52 dependencies on PAY_ELEMENT_TYPES_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 1837: PAY_ELEMENT_TYPES_F elt,

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
1841: AND ell.element_link_id = ele.element_link_id

Line 4113: FROM PAY_ELEMENT_TYPES_F ELT,

4109: ,cp_eff_date in date
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

Line 4143: l_element_name pay_element_types_f.element_name%type;

4139: AND TABLE_NAME = cp_table_name
4140: ORDER BY PROCESS_DATE DESC; -- Line Added by ENUNEZ (04/11/2000) bug# 1235958
4141:
4142: l_ipv_name pay_input_values_f.name%type;
4143: l_element_name pay_element_types_f.element_name%type;
4144: l_proc_warn boolean;
4145: l_proc varchar2(30):='update_eleentval';
4146: l_eff_date date;
4147: l_asg_id number;

Line 4155: from pay_element_types_f elt,

4151: ,input_name in varchar2
4152: ,eff_date in date
4153: ,p_bg_id in number) is
4154: select ipv.uom
4155: from pay_element_types_f elt,
4156: pay_input_values_f ipv
4157: where trunc(eff_date) between elt.effective_start_date
4158: and elt.effective_end_date
4159: and trunc(eff_date) between ipv.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

Line 7002: FROM pay_element_types_f elt

6998: CURSOR C_element_exists(p_element_name IN VARCHAR2,
6999: p_assignment_id IN number,
7000: p_effective_date IN DATE) IS
7001: SELECT '1'
7002: FROM pay_element_types_f elt
7003: ,pay_element_entries_f ele
7004: WHERE elt.element_type_id = ele.element_type_id
7005: AND elt.element_name= p_element_name
7006: AND ele.assignment_id = p_assignment_id