APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2814: ,pay_element_entries_f pee

2810: ,pap.accrual_plan_id
2811: FROM pay_accrual_plans pap
2812: ,pay_element_types_f pet
2813: ,pay_element_links_f pel
2814: ,pay_element_entries_f pee
2815: ,pay_assignment_actions paa
2816: ,pay_payroll_actions ppa
2817: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
2818: AND pel.element_type_id = pet.element_type_id

Line 3050: FROM pay_element_entries_f

3046: /* cursor to get the further element entry info for payslip information */
3047:
3048: CURSOR csr_payslip_info (p_ele_entry_id NUMBER) IS
3049: SELECT ENTRY_INFORMATION1
3050: FROM pay_element_entries_f
3051: where ELEMENT_ENTRY_ID = p_ele_entry_id ;
3052:
3053: -------------------------------
3054: /* Cursor to retrieve run result value of Additional Elements */

Line 3857: ,pay_element_entries_f ee

3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee
3858: ,pay_element_entry_values_f eev1
3859: WHERE asg1.assignment_id = p_assignment_id
3860: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3861: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 3885: ,pay_element_entries_f ee

3881: FROM per_all_assignments_f asg1
3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee
3886: ,pay_element_entry_values_f eev1
3887: WHERE asg1.assignment_id = p_assignment_id
3888: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3889: AND et.element_name = 'Tax'

Line 4323: FROM pay_element_entries_f

4319: /* cursor to get the further element entry info for payslip information */
4320:
4321: CURSOR csr_payslip_info (p_ele_entry_id NUMBER) IS
4322: SELECT ENTRY_INFORMATION1
4323: FROM pay_element_entries_f
4324: where ELEMENT_ENTRY_ID = p_ele_entry_id ;
4325:
4326: ----------------------------------
4327:

Line 4400: ,pay_element_entries_f ee

4396: FROM per_all_assignments_f asg1
4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee
4401: ,pay_element_entry_values_f eev1
4402: WHERE asg1.assignment_id = p_assignment_id
4403: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
4404: AND et.element_name = 'Tax Period Override Element'