DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 303: , pay_element_entry_values_f peev1

299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1
304: , pay_element_entry_values_f peev2
305: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.payroll_action_id = ppa.payroll_action_id
307: AND pee1.assignment_id = paa.assignment_id

Line 304: , pay_element_entry_values_f peev2

300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1
304: , pay_element_entry_values_f peev2
305: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.payroll_action_id = ppa.payroll_action_id
307: AND pee1.assignment_id = paa.assignment_id
308: AND pet.element_name = 'Pension'

Line 346: , pay_element_entry_values_f peev1

342: , pay_element_types_f pet
343: , pay_element_entries_f pee2
344: /* Added for Pension changes */
345: , pay_input_values_f pivf
346: , pay_element_entry_values_f peev1
347: , pay_element_entry_values_f peev2
348: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
349: AND paa.payroll_action_id = ppa.payroll_action_id
350: AND pee1.assignment_id = paa.assignment_id

Line 347: , pay_element_entry_values_f peev2

343: , pay_element_entries_f pee2
344: /* Added for Pension changes */
345: , pay_input_values_f pivf
346: , pay_element_entry_values_f peev1
347: , pay_element_entry_values_f peev2
348: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
349: AND paa.payroll_action_id = ppa.payroll_action_id
350: AND pee1.assignment_id = paa.assignment_id
351: AND pet.element_name = 'Pension'

Line 385: , pay_element_entry_values_f peev1

381: , pay_element_types_f pet
382: , pay_element_entries_f pee2
383: /* Added for Pension changes */
384: , pay_input_values_f pivf
385: , pay_element_entry_values_f peev1
386: , pay_element_entry_values_f peev2
387: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
388: AND paa.payroll_action_id = ppa.payroll_action_id
389: AND pee1.assignment_id = paa.assignment_id

Line 386: , pay_element_entry_values_f peev2

382: , pay_element_entries_f pee2
383: /* Added for Pension changes */
384: , pay_input_values_f pivf
385: , pay_element_entry_values_f peev1
386: , pay_element_entry_values_f peev2
387: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
388: AND paa.payroll_action_id = ppa.payroll_action_id
389: AND pee1.assignment_id = paa.assignment_id
390: AND pet.element_name = 'Pension'

Line 584: FROM pay_element_entry_values_f

580: FUNCTION get_pen_values(p_eff_date DATE,p_ele_type_id NUMBER, p_ee_id NUMBER, p_iv_name VARCHAR2) RETURN VARCHAR2 IS
581:
582: CURSOR csr_get_pen_values(p_eff_date DATE, p_ee_id NUMBER, p_iv_id NUMBER) IS
583: SELECT nvl(screen_entry_value,0)
584: FROM pay_element_entry_values_f
585: WHERE element_entry_id = p_ee_id
586: AND input_value_id = p_iv_id
587: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;
588: