DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_INPUT_VALUES_F

Line 260: pay_input_values_f piv1,

256: pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_element_types_f pet1,
259: pay_element_types_f pet2,
260: pay_input_values_f piv1,
261: pay_input_values_f piv2,
262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,

Line 261: pay_input_values_f piv2,

257: pay_assignment_actions paa,
258: pay_element_types_f pet1,
259: pay_element_types_f pet2,
260: pay_input_values_f piv1,
261: pay_input_values_f piv2,
262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,
265: per_assignments_f paaf,

Line 262: pay_input_values_f piv3,

258: pay_element_types_f pet1,
259: pay_element_types_f pet2,
260: pay_input_values_f piv1,
261: pay_input_values_f piv2,
262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,
265: per_assignments_f paaf,
266: pay_run_types_f prt,

Line 263: pay_input_values_f piv4,

259: pay_element_types_f pet2,
260: pay_input_values_f piv1,
261: pay_input_values_f piv2,
262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,
265: per_assignments_f paaf,
266: pay_run_types_f prt,
267: fnd_territories ft

Line 326: pay_input_values_f piv1,

322: from pay_run_results prr1,
323: pay_payroll_actions ppa,
324: pay_assignment_actions paa,
325: pay_element_types_f pet1,
326: pay_input_values_f piv1,
327: pay_input_values_f piv2,
328: pay_input_values_f piv3,
329: pay_input_values_f piv4,
330: pay_run_types_f prt

Line 327: pay_input_values_f piv2,

323: pay_payroll_actions ppa,
324: pay_assignment_actions paa,
325: pay_element_types_f pet1,
326: pay_input_values_f piv1,
327: pay_input_values_f piv2,
328: pay_input_values_f piv3,
329: pay_input_values_f piv4,
330: pay_run_types_f prt
331: where ppa.payroll_action_id = p_payroll_action_id

Line 328: pay_input_values_f piv3,

324: pay_assignment_actions paa,
325: pay_element_types_f pet1,
326: pay_input_values_f piv1,
327: pay_input_values_f piv2,
328: pay_input_values_f piv3,
329: pay_input_values_f piv4,
330: pay_run_types_f prt
331: where ppa.payroll_action_id = p_payroll_action_id
332: and ppa.business_group_id = p_business_group_id

Line 329: pay_input_values_f piv4,

325: pay_element_types_f pet1,
326: pay_input_values_f piv1,
327: pay_input_values_f piv2,
328: pay_input_values_f piv3,
329: pay_input_values_f piv4,
330: pay_run_types_f prt
331: where ppa.payroll_action_id = p_payroll_action_id
332: and ppa.business_group_id = p_business_group_id
333: and paa.assignment_id = p_assignment_id

Line 476: pay_input_values_f piv1,

472: pay_element_types_f pet,
473: pay_payroll_actions ppa,
474: pay_assignment_actions paa,
475: pay_run_types_f prt,
476: pay_input_values_f piv1,
477: pay_element_entry_values_f peev1
478: where pet.element_name = 'PREV_ER_INFO'
479: and pel.element_link_id = pee.element_link_id
480: and pet.element_type_id = pel.element_type_id

Line 504: l_iv_name pay_input_values_f.name%TYPE;

500: and ppa.payroll_action_id = p_payroll_action_id
501: and ppa.business_group_id = p_business_group_id
502: and peev1.screen_entry_value is not null; -- Bug# 2826658 Added not to archive null values
503:
504: l_iv_name pay_input_values_f.name%TYPE;
505: l_item VARCHAR2(25);
506: l_prepaid_value NUMBER;
507:
508: procedure populate_archive_item(p_item varchar2, p_piv_name varchar2) is