DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 37: pay_assignment_actions pac,

33: 'ARCHIVE_MESSAGE=P',
34: fai.value
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'

Line 58: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

54:
55:
56: PROCEDURE ARCHIVE_CODE
57: (
58: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
59: P_EFFECTIVE_DATE IN DATE
60: );
61:
62: PROCEDURE ARCHIVE_ITEM

Line 65: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

61:
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