APPS.PAY_SG_IRAS_ARCHIVE_SETUP dependencies on PAY_PAYROLL_ACTIONS

Line 12: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

8: -- Action.
9: -- Core Payroll recommends the select has minimal restrictions.
10: -----------------------------------------------------------------------------
11: procedure range_code
12: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
13: , p_sql out nocopy varchar2 )
14: is
15: begin
16: if g_debug then

Line 22: 'pay_payroll_actions ppa ' ||

18: end if;
19: --
20: p_sql := 'select distinct person_id ' ||
21: 'from per_people_f ppf, ' ||
22: 'pay_payroll_actions ppa ' ||
23: 'where ppa.payroll_action_id = :payroll_action_id ' ||
24: 'and ppa.business_group_id = ppf.business_group_id ' ||
25: 'order by ppf.person_id';
26: --

Line 45: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

41: -- re-archive a person, they must ROLLBACK the magtape first, or use the
42: -- standard Re-try, Rollback payroll process.
43: ----------------------------------------------------------------------------
44: procedure assignment_action_code
45: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
46: , p_start_person_id in per_all_people_f.person_id%type
47: , p_end_person_id in per_all_people_f.person_id%type
48: , p_chunk in number )
49: is

Line 65: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

61: asglist t_assignment_list;
62: ----------------------------------------------------------------------------
63: -- Legislative Parameters for Run
64: ----------------------------------------------------------------------------
65: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
66: is
67: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),
68: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
69: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),

Line 75: from pay_payroll_actions

71: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
72: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
73: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
74: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
75: from pay_payroll_actions
76: where payroll_action_id =c_payroll_Action_id;
77: ----------------------------------------------------------------------------
78: -- Cursor Next Assignment Action
79: ----------------------------------------------------------------------------

Line 87: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

83: ----------------------------------------------------------------------------
84: -- Filters Assignments to be processed.
85: ----------------------------------------------------------------------------
86: cursor process_assignments
87: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
88: c_start_person_id in per_all_people_f.person_id%type,
89: c_end_person_id in per_all_people_f.person_id%type )
90: is
91: select distinct a.assignment_id

Line 93: pay_payroll_actions pa

89: c_end_person_id in per_all_people_f.person_id%type )
90: is
91: select distinct a.assignment_id
92: from per_assignments_f a,
93: pay_payroll_actions pa
94: where pa.payroll_action_id = c_payroll_action_id
95: and a.person_id between c_start_person_id and c_end_person_id
96: and a.business_group_id = pa.business_group_id
97: and ( a.effective_start_date <= v_basis_end and a.effective_end_date>= v_basis_start)

Line 117: pay_payroll_actions mpl

113: and not exists
114: ( select null
115: from per_assignments_f paf,
116: pay_assignment_actions mcl,
117: pay_payroll_actions mpl
118: where paf.assignment_id = a.assignment_id
119: and paf.assignment_id = mcl.assignment_id
120: and mpl.payroll_action_id = mcl.payroll_action_id
121: and mpl.business_group_id = pa.business_group_id

Line 137: pay_payroll_actions ppa

133: and exists
134: ( select null
135: from per_assignments_f paf,
136: pay_assignment_actions pac,
137: pay_payroll_actions ppa
138: where paf.assignment_id = a.assignment_id
139: and paf.assignment_id = pac.assignment_id
140: and pac.tax_unit_id = v_legal_entity_id
141: and ppa.payroll_action_id = pac.payroll_action_id

Line 293: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

289: --------------------------------------------------------------
290: -- Initiates IRAS Line Archive Processor
291: --------------------------------------------------------------
292: procedure deinit_code
293: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
294: is
295: l_rep_req_id number;
296: v_magnetic_file_name varchar2(50);
297: v_legal_entity number;

Line 308: from pay_payroll_actions

304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)
308: from pay_payroll_actions
309: where payroll_action_id = p_payroll_action_id;
310: begin
311: if g_debug then
312: hr_utility.trace(l_package_name||'Deinit_Code - Start');