APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

58: p_start_person_id in per_all_people_f.person_id%TYPE,
59: p_end_person_id in per_all_people_f.person_id%TYPE,
60: p_chunk in number)
61: IS
62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
63: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
64: v_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
65: x_hk_archive_message varchar2(1000);
66:

Line 63: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

59: p_end_person_id in per_all_people_f.person_id%TYPE,
60: p_chunk in number)
61: IS
62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
63: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
64: v_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
65: x_hk_archive_message varchar2(1000);
66:
67: CURSOR next_action_id is

Line 64: v_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;

60: p_chunk in number)
61: IS
62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
63: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
64: v_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
65: x_hk_archive_message varchar2(1000);
66:
67: CURSOR next_action_id is
68: SELECT pay_assignment_actions_s.NEXTVAL

Line 68: SELECT pay_assignment_actions_s.NEXTVAL

64: v_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
65: x_hk_archive_message varchar2(1000);
66:
67: CURSOR next_action_id is
68: SELECT pay_assignment_actions_s.NEXTVAL
69: FROM dual;
70:
71:
72:

Line 77: (c_assignment_id in pay_assignment_actions.assignment_id%type,

73: ----------------------
74: --Define Cursor to check EIT
75:
76: cursor check_eit
77: (c_assignment_id in pay_assignment_actions.assignment_id%type,
78: c_legal_entity_id in pay_assignment_actions.tax_unit_id%type,
79: c_reporting_year in number) is
80: SELECT paei.assignment_extra_info_id,
81: paei.assignment_id,

Line 78: c_legal_entity_id in pay_assignment_actions.tax_unit_id%type,

74: --Define Cursor to check EIT
75:
76: cursor check_eit
77: (c_assignment_id in pay_assignment_actions.assignment_id%type,
78: c_legal_entity_id in pay_assignment_actions.tax_unit_id%type,
79: c_reporting_year in number) is
80: SELECT paei.assignment_extra_info_id,
81: paei.assignment_id,
82: paei.aei_information1,

Line 112: pay_assignment_actions paa

108: per_assignments_f paaf,
109: pay_payroll_actions ppa, --magtape action
110: pay_payroll_actions ppa2,--report action
111: pay_payroll_actions ppa3,--archive action
112: pay_assignment_actions paa
113: where
114: ppa.payroll_action_id = c_payroll_action_id
115: and papf.person_id between c_start_person_id and c_end_person_id
116: and papf.person_id = paaf.person_id

Line 130: pay_assignment_actions paa1

126: (select locked_action_id
127: from pay_action_interlocks pai,
128: pay_payroll_actions ppa1,
129: pay_payroll_actions ppa2,
130: pay_assignment_actions paa1
131: where pai.locked_action_id = paa.assignment_action_id
132: and ppa1.action_type='X'
133: and ppa1.report_type = 'HK_IR56B_MAGTAPE'
134: and ppa2.action_type='X'