APPS.PAY_KR_BATCH_YEA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 12: pay_payroll_actions ppa

8: 'select
9: distinct pds.person_id
10: from per_periods_of_service pds,
11: per_assignments_f asg,
12: pay_payroll_actions ppa
13: where ppa.payroll_action_id = :payroll_action_id
14: and asg.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''PAYROLL_ID'', null))
15: and ppa.effective_date between asg.effective_start_date and asg.effective_end_date
16: and pds.period_of_service_id = asg.period_of_service_id

Line 33: report_type pay_payroll_actions.report_type%TYPE,

29: g_package varchar2(31) := ' pay_kr_batch_yea_pkg.';
30:
31: type t_pact is record(
32: payroll_action_id number,
33: report_type pay_payroll_actions.report_type%TYPE,
34: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
35: report_category pay_payroll_actions.report_category%TYPE,
36: business_group_id number,
37: effective_date date,

Line 34: report_qualifier pay_payroll_actions.report_qualifier%TYPE,

30:
31: type t_pact is record(
32: payroll_action_id number,
33: report_type pay_payroll_actions.report_type%TYPE,
34: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
35: report_category pay_payroll_actions.report_category%TYPE,
36: business_group_id number,
37: effective_date date,
38: payroll_id number,

Line 35: report_category pay_payroll_actions.report_category%TYPE,

31: type t_pact is record(
32: payroll_action_id number,
33: report_type pay_payroll_actions.report_type%TYPE,
34: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
35: report_category pay_payroll_actions.report_category%TYPE,
36: business_group_id number,
37: effective_date date,
38: payroll_id number,
39: consolidation_set_id number,

Line 54: update pay_payroll_actions

50: is
51: begin
52: initialization_code(p_payroll_action_id);
53:
54: update pay_payroll_actions
55: set payroll_id = g_pact.payroll_id
56: ,consolidation_set_id = g_pact.consolidation_set_id
57: where payroll_action_id = p_payroll_action_id;
58:

Line 91: from pay_payroll_actions ppa

87: ,g_pact.bal_adj_action_id
88: ,g_pact.payroll_id
89: ,g_pact.consolidation_set_id
90: --
91: from pay_payroll_actions ppa
92: where ppa.payroll_action_id = p_payroll_action_id;
93: END;
94:
95: END IF;

Line 118: pay_payroll_actions ppa

114: asg.assignment_id
115: --
116: from per_assignments_f asg,
117: per_periods_of_service pds,
118: pay_payroll_actions ppa
119: --
120: where ppa.payroll_action_id = p_payroll_action_id
121: and pds.person_id between p_start_person_id and p_end_person_id
122: and pds.business_group_id = ppa.business_group_id

Line 135: pay_payroll_actions ppa2,

131: ordered
132: use_nl(ppa2)
133: */ null
134: from pay_assignment_actions paa2,
135: pay_payroll_actions ppa2,
136: pay_action_classifications pac
137: where paa2.assignment_id = asg.assignment_id
138: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
139: and paa2.source_action_id is null

Line 149: from pay_payroll_actions ppa4,

145: -- Exclude if Archival has already been processed.
146: --
147: and not exists(
148: select null
149: from pay_payroll_actions ppa4,
150: pay_assignment_actions paa4
151: where paa4.assignment_id = asg.assignment_id
152: and paa4.source_action_id is null
153: and ppa4.payroll_action_id = paa4.payroll_action_id

Line 231: pay_payroll_actions ppa

227: asg.assignment_id
228: --
229: from per_assignments_f asg,
230: per_periods_of_service pds,
231: pay_payroll_actions ppa
232: --
233: where ppa.payroll_action_id = p_payroll_action_id
234: and pds.person_id between p_start_person_id and p_end_person_id
235: and pds.business_group_id = ppa.business_group_id

Line 248: pay_payroll_actions ppa2,

244: ordered
245: use_nl(ppa2)
246: */ null
247: from pay_assignment_actions paa2,
248: pay_payroll_actions ppa2,
249: pay_action_classifications pac
250: where paa2.assignment_id = asg.assignment_id
251: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
252: and paa2.source_action_id is null

Line 262: from pay_payroll_actions ppa4,

258: -- Include if Normal / Interim archive has been processed.
259: --
260: and exists(
261: select null
262: from pay_payroll_actions ppa4,
263: pay_assignment_actions paa4
264: where paa4.assignment_id = asg.assignment_id
265: and paa4.source_action_id is null
266: and ppa4.payroll_action_id = paa4.payroll_action_id

Line 277: from pay_payroll_actions ppa3,

273: -- Exclude if future YEA in the same calendar year exists.
274: --
275: and not exists(
276: select null
277: from pay_payroll_actions ppa3,
278: pay_assignment_actions paa3
279: where paa3.assignment_id = asg.assignment_id
280: and paa3.source_action_id is null
281: and ppa3.payroll_action_id = paa3.payroll_action_id