APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

33: /********************************************************
34: * Procedure to fetch RANGE CODE *
35: **********************************************************/
36: procedure range_code
37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
38: p_sql out nocopy varchar2
39: )
40: is
41: Begin

Line 45: 'pay_payroll_actions ppa ' ||

41: Begin
42: hr_utility.set_location('Start of range_code',1);
43: p_sql := 'SELECT distinct person_id ' ||
44: 'FROM per_people_f ppf, ' ||
45: 'pay_payroll_actions ppa ' ||
46: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||
47: 'AND ppa.business_group_id = ppf.business_group_id ' ||
48: 'ORDER BY ppf.person_id';
49: hr_utility.set_location('End of range_code',2);

Line 57: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

53: * Procedure to fetch ASSIGNMENT ACTION CODE *
54: **********************************************************/
55:
56: PROCEDURE assignment_action_code
57: (p_payroll_action_id in pay_payroll_actions.payroll_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

Line 96: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

92:
93:
94: --------------------
95: CURSOR process_assignments
96: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
97: c_start_person_id in per_all_people_f.person_id%TYPE,
98: c_end_person_id in per_all_people_f.person_id%TYPE)
99:
100: IS

Line 109: pay_payroll_actions ppa, --magtape action

105: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa3.legislative_parameters) legal_entity_id,
106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year
107: from per_people_f papf,
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

Line 110: pay_payroll_actions ppa2,--report action

106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year
107: from per_people_f papf,
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

Line 111: pay_payroll_actions ppa3,--archive action

107: from per_people_f papf,
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

Line 128: pay_payroll_actions ppa1,

124: and paa.action_status = 'C' /* Bug No : 2829320 - To prevent Magtape fetching errored archive records */
125: and not exists /* dont process locked assignments, bug 7324233, it should only lock the assignments which has magtape generated previously */
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'

Line 129: pay_payroll_actions ppa2,

125: and not exists /* dont process locked assignments, bug 7324233, it should only lock the assignments which has magtape generated previously */
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'