APPS.PAY_ZA_TAX_REG_AR dependencies on PAY_PAYROLL_ACTIONS

Line 50: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

46:
47: FUNCTION get_parameter(p_parameter_string IN VARCHAR2,
48: p_token IN VARCHAR2) RETURN VARCHAR2
49: IS
50: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
51: l_start_pos NUMBER;
52: l_delimiter varchar2(1):=' ';
53: BEGIN
54: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

Line 75: leg_param pay_payroll_actions.legislative_parameters%type;

71: sqlstr out nocopy varchar2)
72: is
73: l_proc constant varchar2(80) := g_package ||'range_cursor';
74:
75: leg_param pay_payroll_actions.legislative_parameters%type;
76:
77: begin
78: -- hr_utility.trace_on(null,'ZATAXREGAR');
79: hr_utility.set_location('Entering: '||l_proc,10);

Line 85: from pay_payroll_actions

81:
82: -- Retrieve legislative parameters from the archiver payroll action
83: select legislative_parameters
84: into leg_param
85: from pay_payroll_actions
86: where payroll_action_id = pactid;
87:
88: hr_utility.set_location('leg_param:'||leg_param,20);
89:

Line 104: pay_payroll_actions PPA

100: sqlstr :=
101: 'SELECT distinct PAF.person_id
102: FROM per_assignments_f PAF,
103: pay_payrolls_f PPY,
104: pay_payroll_actions PPA
105: WHERE PPA.payroll_action_id = :payroll_action_id
106: AND PAF.business_group_id = PPA.business_group_id
107: AND PPY.payroll_id = PAF.payroll_id
108: AND PPY.payroll_id = '||g_payroll_id||'

Line 117: pay_payroll_actions PPA,

113: sqlstr :=
114: 'SELECT distinct PAF.person_id
115: FROM per_assignments_f PAF,
116: pay_payrolls_f PPY,
117: pay_payroll_actions PPA,
118: per_assignment_extra_info AEI
119: WHERE PPA.payroll_action_id = :payroll_action_id
120: AND PAF.business_group_id = PPA.business_group_id
121: AND PPY.payroll_id = PAF.payroll_id

Line 175: pay_payroll_actions ppa2

171: and p_period_end_date between ptp.start_date and ptp.end_date
172: AND exists
173: ( select 1 from
174: pay_assignment_actions paa3,
175: pay_payroll_actions ppa2
176: where paa3.assignment_id = PAF.assignment_id
177: and paa3.payroll_action_id = ppa2.payroll_action_id
178: and ppa2.action_type IN ('R', 'Q', 'I', 'B', 'V')
179: and ppa2.time_period_id >= (select MIN(ptp1.time_period_id) min_time_period

Line 193: leg_param pay_payroll_actions.legislative_parameters%type;

189: l_proc constant varchar2(80) := g_package ||'action_creation';
190:
191: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
192:
193: leg_param pay_payroll_actions.legislative_parameters%type;
194:
195: begin
196: hr_utility.set_location('Entering: '||l_proc,10);
197: hr_utility.set_location('chunk: '||chunk,10);

Line 202: from pay_payroll_actions

198:
199: -- Retrieve legislative parameters from the archiver payroll action
200: select legislative_parameters
201: into leg_param
202: from pay_payroll_actions
203: where payroll_action_id = pactid;
204:
205: hr_utility.set_location('leg_param:'||leg_param,20);
206:

Line 256: leg_param pay_payroll_actions.legislative_parameters%type;

252: procedure archinit(p_payroll_action_id in number)
253: is
254: l_proc constant varchar2(80) := g_package ||'archinit';
255:
256: leg_param pay_payroll_actions.legislative_parameters%type;
257:
258:
259: begin
260: hr_utility.set_location('Entering: '||l_proc,10);

Line 271: from pay_payroll_actions

267:
268: -- Retrieve legislative parameters from the archiver payroll action
269: select legislative_parameters
270: into leg_param
271: from pay_payroll_actions
272: where payroll_action_id = p_payroll_action_id;
273:
274: hr_utility.set_location('leg_param:'||leg_param,20);
275:

Line 325: leg_param pay_payroll_actions.legislative_parameters%type;

321: l_period_end_date per_time_periods.end_date%TYPE;
322: l_tot_employees NUMBER;
323: l_tot_assignments NUMBER;
324:
325: leg_param pay_payroll_actions.legislative_parameters%type;
326:
327: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
328: l_action_info_id number;
329: l_ovn number;

Line 327: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

323: l_tot_assignments NUMBER;
324:
325: leg_param pay_payroll_actions.legislative_parameters%type;
326:
327: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
328: l_action_info_id number;
329: l_ovn number;
330: l_qtr_num number;
331: l_pay_advice_date per_time_periods.end_date%type;

Line 340: from pay_payroll_actions ppa,

336:
337: -- Retrieve legislative parameters from the archiver payroll action
338: select ppa.legislative_parameters, ppa.payroll_action_id
339: into leg_param, l_payroll_action_id
340: from pay_payroll_actions ppa,
341: pay_assignment_actions paa
342: where paa.payroll_action_id = ppa.payroll_action_id
343: and paa.assignment_action_id = p_assactid;
344:

Line 498: from pay_payroll_actions ppa

494: ppa.effective_date effective_date,
495: ppf.payroll_name payroll_name,
496: ptp.start_date start_date,
497: ptp.end_date end_date
498: from pay_payroll_actions ppa
499: , pay_assignment_actions paa
500: , pay_action_information pai
501: , pay_all_payrolls_f ppf
502: , per_time_periods ptp

Line 519: leg_param pay_payroll_actions.legislative_parameters%type;

515:
516: xml_layout boolean;
517: l_request_id fnd_concurrent_requests.request_id%TYPE;
518:
519: leg_param pay_payroll_actions.legislative_parameters%type;
520:
521: l_legal_entity_name varchar2(240);
522: l_action_info_id number;
523: l_ovn number;

Line 530: from pay_payroll_actions

526:
527: -- Retrieve legislative parameters from the archiver payroll action
528: select legislative_parameters
529: into leg_param
530: from pay_payroll_actions
531: where payroll_action_id = pactid;
532:
533: hr_utility.set_location('leg_param:'||leg_param,10);
534:

Line 675: FROM pay_payroll_actions

671: FROM pay_assignment_actions
672: WHERE payroll_action_id = p_payroll_action_id;
673:
674: DELETE
675: FROM pay_payroll_actions
676: WHERE payroll_action_id = p_payroll_action_id;
677:
678: COMMIT;
679: