APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 78: token_val pay_payroll_actions.legislative_parameters%type;

74: parameter_list varchar2
75: ) return varchar2 is
76: start_ptr number;
77: end_ptr number;
78: token_val pay_payroll_actions.legislative_parameters%type;
79: par_value pay_payroll_actions.legislative_parameters%type;
80:
81: begin
82:

Line 79: par_value pay_payroll_actions.legislative_parameters%type;

75: ) return varchar2 is
76: start_ptr number;
77: end_ptr number;
78: token_val pay_payroll_actions.legislative_parameters%type;
79: par_value pay_payroll_actions.legislative_parameters%type;
80:
81: begin
82:
83: token_val := name || '=';

Line 172: from pay_payroll_actions

168: Order By effective_start_date;
169:
170: cursor csr_archive_effective_date is
171: select effective_date
172: from pay_payroll_actions
173: where payroll_action_id = pactid;
174:
175: l_proc varchar2(200);
176: l_payroll_id number;

Line 208: from pay_payroll_actions

204:
205: -- Retrieve legislative parameters from the archiver payroll action
206: select legislative_parameters
207: into leg_param
208: from pay_payroll_actions
209: where payroll_action_id = pactid;
210:
211: l_payroll_id := get_parameter('PAYROLL_ID', leg_param);
212: l_business_grp_id := get_parameter('BUS_GRP_ID', leg_param);

Line 306: --Update the payroll_id column of pay_payroll_actions

302: where payroll_id = l_payroll_id
303: and g_start_period_date between start_date and end_date);
304: end;
305:
306: --Update the payroll_id column of pay_payroll_actions
307: update pay_payroll_actions
308: set payroll_id = l_payroll_id
309: where payroll_action_id = pactid;
310:

Line 307: update pay_payroll_actions

303: and g_start_period_date between start_date and end_date);
304: end;
305:
306: --Update the payroll_id column of pay_payroll_actions
307: update pay_payroll_actions
308: set payroll_id = l_payroll_id
309: where payroll_action_id = pactid;
310:
311: sqlstr :=

Line 315: pay_payroll_actions ppa

311: sqlstr :=
312: 'select distinct ass.person_id
313: from per_assignments_f ass,
314: pay_payrolls_f ppf,
315: pay_payroll_actions ppa
316: where ppa.payroll_action_id = :payroll_action_id
317: and ass.business_group_id = ppa.business_group_id
318: and ass.assignment_type = ''E''
319: and ppf.payroll_id = ass.payroll_id

Line 396: from pay_payroll_actions ppa,

392: AND ppt.system_person_type in ('EMP','EX_EMP')
393: AND asg.assignment_id = paei.assignment_id
394: AND paei.information_type = 'ZA_SPECIFIC_INFO'
395: AND exists (select 1
396: from pay_payroll_actions ppa,
397: pay_assignment_actions paa
398: where
399: ppa.payroll_id=asg.payroll_id
400: and paa.assignment_id=asg.assignment_id

Line 423: from pay_payroll_actions

419:
420: -- Retrieve legislative parameters from the archiver payroll action
421: select legislative_parameters
422: into leg_param
423: from pay_payroll_actions
424: where payroll_action_id = pactid;
425:
426: l_payroll_id := get_parameter('PAYROLL_ID', leg_param);
427: l_end_prd_id := get_parameter('END_PERIOD_ID', leg_param);

Line 573: , pay_payroll_actions ppa2

569: MAX(paa2.assignment_action_id)
570: FROM
571: pay_run_results prr2
572: , pay_assignment_actions paa2
573: , pay_payroll_actions ppa2
574: WHERE
575: prr2.element_type_id = pet.element_type_id
576: AND prr2.run_result_id = prr2.run_result_id
577: AND prr2.assignment_action_id = paa2.assignment_action_id

Line 709: pay_payroll_actions ppa,

705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);
706: select max(paa.action_sequence)
707: into l_run_action_seq
708: from pay_assignment_actions paa,
709: pay_payroll_actions ppa,
710: per_time_periods ptp
711: where paa.assignment_id = p_asg_id
712: and paa.action_status IN ('C','S') --10376999
713: and paa.payroll_action_id = ppa.payroll_action_id

Line 1085: from pay_payroll_actions ppa,

1081:
1082: -- Retrieve legislative parameters from the archiver payroll action
1083: select ppa.legislative_parameters, ppa.payroll_action_id
1084: into leg_param , pactid
1085: from pay_payroll_actions ppa,
1086: pay_assignment_actions paa
1087: where paa.assignment_action_id = p_assactid
1088: and ppa.payroll_action_id = paa.payroll_action_id;
1089:

Line 1191: from pay_payroll_actions ppa

1187: cursor csr_dup_person is
1188: select distinct
1189: pai.action_information30 person_id
1190: , pai.action_information9 asg_type
1191: from pay_payroll_actions ppa
1192: , pay_assignment_actions paa
1193: , pay_action_information pai
1194: , pay_assignment_actions paa2
1195: , pay_action_information pai2

Line 1334: from pay_payroll_actions

1330:
1331: -- Retrieve legislative parameters from the archiver payroll action
1332: select legislative_parameters
1333: into leg_param
1334: from pay_payroll_actions
1335: where payroll_action_id = pactid;
1336:
1337: --Bug 14272272
1338: if nvl(g_coida_limit1,0) = 0 then