APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 385: FROM pay_element_entries_f pee

381: AND paf.effective_end_date >= g_start_date
382: AND ppa.business_group_id =g_bg_id
383: UNION
384: SELECT paf1.assignment_id
385: FROM pay_element_entries_f pee
386: ,per_assignments_f paf1
387: WHERE paf1.business_group_id = g_bg_id
388: AND paf1.person_id BETWEEN p_start_person AND p_end_person
389: AND pee.element_type_id = g_chln_element_id

Line 2167: FROM pay_element_entries_f pee

2163: IS
2164: CURSOR csr_challan_asg
2165: IS
2166: SELECT pee.element_entry_id
2167: FROM pay_element_entries_f pee
2168: WHERE pee.element_type_id = g_chln_element_id
2169: AND pee.effective_start_date <= g_fin_end_date
2170: AND pee.effective_end_date >= g_fin_start_date
2171: AND pee.assignment_id = p_assignment_id

Line 2253: (element_entry_id pay_element_entries_f.element_entry_id%TYPE);

2249:
2250: t_person_tab t_person_data_tab_type;
2251:
2252: TYPE t_challan_entry_asg_rec IS RECORD
2253: (element_entry_id pay_element_entries_f.element_entry_id%TYPE);
2254:
2255: TYPE t_challan_entry_asg_tab_type is table of t_challan_entry_asg_rec index by binary_integer;
2256: t_challan_entry_asg_tab t_challan_entry_asg_tab_type;
2257: