APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2825: ,pay_element_entries_f pee

2821: ,pap.accrual_plan_id
2822: FROM pay_accrual_plans pap
2823: ,pay_element_types_f pet
2824: ,pay_element_links_f pel
2825: ,pay_element_entries_f pee
2826: ,pay_assignment_actions paa
2827: ,pay_payroll_actions ppa
2828: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
2829: AND pel.element_type_id = pet.element_type_id

Line 3061: FROM pay_element_entries_f

3057: /* cursor to get the further element entry info for payslip information */
3058:
3059: CURSOR csr_payslip_info (p_ele_entry_id NUMBER) IS
3060: SELECT ENTRY_INFORMATION1
3061: FROM pay_element_entries_f
3062: where ELEMENT_ENTRY_ID = p_ele_entry_id ;
3063:
3064: -------------------------------
3065: /* Cursor to retrieve run result value of Additional Elements */

Line 3868: ,pay_element_entries_f ee

3864: ,per_all_people_f per
3865: ,pay_element_links_f el
3866: ,pay_element_types_f et
3867: ,pay_input_values_f iv1
3868: ,pay_element_entries_f ee
3869: ,pay_element_entry_values_f eev1
3870: WHERE asg1.assignment_id = p_assignment_id
3871: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3872: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 3896: ,pay_element_entries_f ee

3892: FROM per_all_assignments_f asg1
3893: ,pay_element_links_f el
3894: ,pay_element_types_f et
3895: ,pay_input_values_f iv1
3896: ,pay_element_entries_f ee
3897: ,pay_element_entry_values_f eev1
3898: WHERE asg1.assignment_id = p_assignment_id
3899: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3900: AND et.element_name = 'Tax'

Line 4334: FROM pay_element_entries_f

4330: /* cursor to get the further element entry info for payslip information */
4331:
4332: CURSOR csr_payslip_info (p_ele_entry_id NUMBER) IS
4333: SELECT ENTRY_INFORMATION1
4334: FROM pay_element_entries_f
4335: where ELEMENT_ENTRY_ID = p_ele_entry_id ;
4336:
4337: ----------------------------------
4338:

Line 4411: ,pay_element_entries_f ee

4407: FROM per_all_assignments_f asg1
4408: ,pay_element_links_f el
4409: ,pay_element_types_f et
4410: ,pay_input_values_f iv1
4411: ,pay_element_entries_f ee
4412: ,pay_element_entry_values_f eev1
4413: WHERE asg1.assignment_id = p_assignment_id
4414: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
4415: AND et.element_name = 'Tax Period Override Element'