APPS.PAY_FR_CPAM_PREPROCESSOR dependencies on PAY_ELEMENT_LINKS_F

Line 25: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet

21: g_proc_net_rt_iv_id pay_input_values_f.input_value_id%type;
22:
23: CURSOR C_info_entry(p_element_entry_id IN NUMBER) IS
24: SELECT 'X' dum
25: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet
26: WHERE pee.element_link_id = pel.element_link_id
27: AND pet.element_type_id = pel.element_type_id
28: AND pet.element_name = 'FR_SICKNESS_CPAM_INFO'
29: AND pee.element_entry_id = p_element_entry_id;

Line 85: FROM pay_element_types_f pet, pay_element_links_f pel, pay_element_links_f pel1

81: and pee.element_entry_id = p_element_entry_id;
82: --
83: CURSOR C_element_link(p_element_type_id IN NUMBER,p_source_element_link_id IN NUMBER, p_effective_start_date IN DATE) IS
84: SELECT pel.element_link_id
85: FROM pay_element_types_f pet, pay_element_links_f pel, pay_element_links_f pel1
86: WHERE pet.element_type_id = pel.element_type_id
87: AND pel.business_group_id = pel1.business_group_id
88: AND pet.element_type_id = p_element_type_id
89: AND p_effective_start_date BETWEEN pel.effective_start_date AND pel.effective_end_date

Line 110: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,

106: rec_element_link c_element_link%ROWTYPE;
107:
108: CURSOR C_info_entries(p_assignment_id IN Number, p_start_date IN Date, p_end_date IN Date, p_curr_entry_id IN Number) IS
109: SELECT pev.effective_start_date
110: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,
111: pay_input_values_f piv, pay_element_entry_values_f pev
112: WHERE pee.element_link_id = pel.element_link_id
113: AND pet.element_type_id = pel.element_type_id
114: AND pee.element_entry_id= pev.element_entry_id

Line 164: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet

160: AND pasg.assignment_id = p_assignment_id;
161:
162: CURSOR C_proc_entry(p_element_entry_id IN NUMBER) IS
163: SELECT 'X' dum
164: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet
165: WHERE pee.element_link_id = pel.element_link_id
166: AND pet.element_type_id = pel.element_type_id
167: AND pet.element_name = 'FR_SICKNESS_CPAM_PROCESS'
168: AND pee.creator_type IN ('F','H')