APPS.PAY_FR_CPAM_PREPROCESSOR dependencies on PAY_ELEMENT_ENTRIES_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 75: FROM pay_element_types_f pet, pay_element_entries_f pee,

71: ,NULL)) Gross_Daily_Rate,
72: max(decode(eev.input_value_id,g_info_net_rt_iv_id
73: ,to_number(eev.screen_entry_value)
74: ,NULL)) Net_Daily_Rate
75: FROM pay_element_types_f pet, pay_element_entries_f pee,
76: pay_input_values_f piv, pay_element_entry_values_f eev
77: WHERE pee.element_entry_id = eev.element_entry_id
78: and pet.element_type_id = piv.element_type_id
79: and piv.input_value_id = eev.input_value_id

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')

Line 513: l_assignment_id pay_element_entries_f.assignment_id%TYPE;

509: p_datetrack_mode IN VARCHAR2
510: ) IS
511: rec_info_entry c_info_entry%ROWTYPE;
512: rec_element_link c_element_link%ROWTYPE;
513: l_assignment_id pay_element_entries_f.assignment_id%TYPE;
514:
515: CURSOR C_linked_process_entries(p_element_entry_id IN NUMBER, p_assignment_id IN NUMBER) IS
516: SELECT pee.element_entry_id
517: FROM pay_element_entries_f pee

Line 517: FROM pay_element_entries_f pee

513: l_assignment_id pay_element_entries_f.assignment_id%TYPE;
514:
515: CURSOR C_linked_process_entries(p_element_entry_id IN NUMBER, p_assignment_id IN NUMBER) IS
516: SELECT pee.element_entry_id
517: FROM pay_element_entries_f pee
518: WHERE pee.entry_information_category = 'FR_CPAM PROCESS INFORMATION'
519: AND pee.assignment_id = p_assignment_id
520: AND pee.entry_information1 = to_char(p_element_entry_id);
521: