APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 384: FROM pay_element_entries_f pee

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

Line 2273: FROM pay_element_entries_f pee

2269: IS
2270: CURSOR csr_challan_asg
2271: IS
2272: SELECT pee.element_entry_id
2273: FROM pay_element_entries_f pee
2274: WHERE pee.element_type_id = g_chln_element_id
2275: AND pee.effective_start_date <= g_fin_end_date
2276: AND pee.effective_end_date >= g_fin_start_date
2277: AND pee.assignment_id = p_assignment_id

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

2355:
2356: t_person_tab t_person_data_tab_type;
2357:
2358: TYPE t_challan_entry_asg_rec IS RECORD
2359: (element_entry_id pay_element_entries_f.element_entry_id%TYPE);
2360:
2361: TYPE t_challan_entry_asg_tab_type is table of t_challan_entry_asg_rec index by binary_integer;
2362: t_challan_entry_asg_tab t_challan_entry_asg_tab_type;
2363: