APPS.PAY_SG_IRAS_AMEND_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 67: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

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

Line 79: from pay_payroll_actions

75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
79: from pay_payroll_actions
80: where payroll_action_id =c_payroll_Action_id;
81: ----------------------------------------------------------------------------
82: -- Cursor Next Assignment Action
83: ----------------------------------------------------------------------------

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

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

Line 97: pay_payroll_actions pa

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

Line 124: pay_payroll_actions mpl

120: and exists
121: ( select null
122: from per_assignments_f paf,
123: pay_assignment_actions mcl,
124: pay_payroll_actions mpl
125: where paf.assignment_id = a.assignment_id
126: and paf.assignment_id = mcl.assignment_id
127: and mpl.payroll_action_id = mcl.payroll_action_id
128: and mpl.business_group_id = pa.business_group_id

Line 144: pay_payroll_actions ppa

140: and exists
141: ( select null
142: from per_assignments_f paf,
143: pay_assignment_actions pac,
144: pay_payroll_actions ppa
145: where paf.assignment_id = a.assignment_id
146: and paf.assignment_id = pac.assignment_id
147: and pac.tax_unit_id = v_legal_entity_id
148: and ppa.payroll_action_id = pac.payroll_action_id

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

298: --------------------------------------------------------------
299: -- Initiates IRAS Line Archive Processor
300: --------------------------------------------------------------
301: procedure deinit_code
302: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
303: is
304: l_rep_req_id number;
305: v_magnetic_file_name varchar2(50);
306: v_le number;

Line 322: from pay_payroll_actions

318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
322: from pay_payroll_actions
323: where payroll_action_id = p_payroll_action_id;
324: begin
325: if g_debug then
326: hr_utility.trace(l_package_name||'Deinit_Code - Start');