DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_INPUT_VALUES_F

Line 265: pay_input_values_f piv1,

261: pay_payroll_actions ppa,
262: pay_assignment_actions paa,
263: pay_element_types_f pet1,
264: pay_element_types_f pet2,
265: pay_input_values_f piv1,
266: pay_input_values_f piv2,
267: pay_input_values_f piv3,
268: pay_input_values_f piv4,
269: per_people_f pap,

Line 266: pay_input_values_f piv2,

262: pay_assignment_actions paa,
263: pay_element_types_f pet1,
264: pay_element_types_f pet2,
265: pay_input_values_f piv1,
266: pay_input_values_f piv2,
267: pay_input_values_f piv3,
268: pay_input_values_f piv4,
269: per_people_f pap,
270: per_assignments_f paaf,

Line 267: pay_input_values_f piv3,

263: pay_element_types_f pet1,
264: pay_element_types_f pet2,
265: pay_input_values_f piv1,
266: pay_input_values_f piv2,
267: pay_input_values_f piv3,
268: pay_input_values_f piv4,
269: per_people_f pap,
270: per_assignments_f paaf,
271: pay_run_types_f prt,

Line 268: pay_input_values_f piv4,

264: pay_element_types_f pet2,
265: pay_input_values_f piv1,
266: pay_input_values_f piv2,
267: pay_input_values_f piv3,
268: pay_input_values_f piv4,
269: per_people_f pap,
270: per_assignments_f paaf,
271: pay_run_types_f prt,
272: fnd_territories ft,

Line 335: pay_input_values_f piv1,

331: from pay_run_results prr1,
332: pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,
337: pay_input_values_f piv3,
338: pay_input_values_f piv4,
339: pay_run_types_f prt

Line 336: pay_input_values_f piv2,

332: pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,
337: pay_input_values_f piv3,
338: pay_input_values_f piv4,
339: pay_run_types_f prt
340: where ppa.payroll_action_id = p_payroll_action_id

Line 337: pay_input_values_f piv3,

333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,
337: pay_input_values_f piv3,
338: pay_input_values_f piv4,
339: pay_run_types_f prt
340: where ppa.payroll_action_id = p_payroll_action_id
341: and ppa.business_group_id = p_business_group_id

Line 338: pay_input_values_f piv4,

334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,
337: pay_input_values_f piv3,
338: pay_input_values_f piv4,
339: pay_run_types_f prt
340: where ppa.payroll_action_id = p_payroll_action_id
341: and ppa.business_group_id = p_business_group_id
342: and paa.assignment_id = p_assignment_id

Line 485: pay_input_values_f piv1,

481: pay_element_types_f pet,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa,
484: pay_run_types_f prt,
485: pay_input_values_f piv1,
486: pay_element_entry_values_f peev1
487: where pet.element_name = v_element_name
488: and pel.element_link_id = pee.element_link_id
489: and pet.element_type_id = pel.element_type_id

Line 513: l_iv_name pay_input_values_f.name%TYPE;

509: and ppa.payroll_action_id = p_payroll_action_id
510: and ppa.business_group_id = p_business_group_id
511: and peev1.screen_entry_value is not null; -- Bug# 2826658 Added not to archive null values
512:
513: l_iv_name pay_input_values_f.name%TYPE;
514: l_item VARCHAR2(25);
515: l_prepaid_value NUMBER;
516:
517: procedure populate_archive_item(p_item varchar2,p_element_name varchar2, p_piv_name varchar2) is