DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 39: ff_archive_items fai

35: FROM per_all_assignments_f paa,
36: pay_payroll_actions ppa,
37: pay_assignment_actions pac,
38: ff_database_items fdi,
39: ff_archive_items fai
40: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
41: AND pac.action_status = 'C'
42: AND ppa.payroll_action_id = pac.payroll_action_id
43: AND paa.assignment_id = pac.assignment_id

Line 66: p_archive_value IN ff_archive_items.value%TYPE

62: PROCEDURE ARCHIVE_ITEM
63: (
64: p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
65: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
66: p_archive_value IN ff_archive_items.value%TYPE
67: );
68:
69: PROCEDURE ASSIGNMENT_ACTION_CODE
70: (