APPS.PAY_NEGBAL_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 137: leg_param pay_payroll_actions.legislative_parameters%type;

133: --
134: ----------------------------------- range_cursor ----------------------------------
135: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
136: l_payroll_id number;
137: leg_param pay_payroll_actions.legislative_parameters%type;
138: l_state pay_us_states.state_abbrev%type;
139: --
140: begin
141: select legislative_parameters,

Line 146: from pay_payroll_actions ppa

142: pay_negbal_pkg.get_parameter('TRANSFER_STATE',
143: ppa.legislative_parameters)
144: into leg_param,
145: l_state
146: from pay_payroll_actions ppa
147: where ppa.payroll_action_id = pactid;
148:
149:
150: /* Negative Balance Code */

Line 158: pay_payroll_actions PPA

154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,
157: pay_us_asg_reporting puar,
158: pay_payroll_actions PPA
159: WHERE PPA.payroll_action_id = :payroll_action_id
160: AND SR.state_code = '''||l_state||'''
161: AND substr(SR.jurisdiction_code,1,2) = substr(puar.jurisdiction_code,1,2)
162: AND ASG.assignment_id = puar.assignment_id

Line 222: pay_payroll_actions ppa,

218: paa.tax_unit_id tax_unit_id,
219: ppa.effective_date effective_end_date,
220: sr.jurisdiction_code jurisdiction_code
221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch

Line 226: pay_payroll_actions ppa_arch

222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch
227: WHERE ppa_arch.payroll_action_id = pactid
228: AND asg.person_id between stperson and endperson
229: AND asg.business_group_id + 0 = ppa_arch.business_group_id
230: AND asg.assignment_type = 'E'

Line 237: pay_payroll_actions ppa1,

233: AND paa.assignment_id = asg.assignment_id
234: AND (paa.action_sequence,asg.person_id,paa.tax_unit_id)
235: in (select max(paa1.action_sequence),paf1.person_id, paa1.tax_unit_id
236: from pay_action_classifications pac,
237: pay_payroll_actions ppa1,
238: pay_assignment_actions paa1,
239: per_assignments_f paf1
240: where paf1.person_id = asg.person_id
241: AND paf1.business_group_id + 0 = ppa_arch.business_group_id

Line 295: from pay_payroll_actions ppa

291: l_qtr_start,
292: l_qtr_end,
293: l_year_start,
294: l_year_end
295: from pay_payroll_actions ppa
296: where ppa.payroll_action_id = pactid;
297:
298: /* New York state settings NB. the difference is that the criteria for
299: selecting people in the 4th quarter is different to that used for the

Line 415: from pay_payroll_actions ppa,

411: begin
412:
413: hr_utility.set_location('pay_negbal_pkg.sort_action',1);
414: sqlstr := 'select paa.rowid
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_all_assignments_f paf, -- #1894165
418: hr_organization_units hou,
419: hr_organization_units hou1

Line 456: token_val pay_payroll_actions.legislative_parameters%type;

452: parameter_list varchar2) return varchar2
453: is
454: start_ptr number;
455: end_ptr number;
456: token_val pay_payroll_actions.legislative_parameters%type;
457: par_value pay_payroll_actions.legislative_parameters%type;
458: begin
459: --
460: token_val := name||'=';

Line 457: par_value pay_payroll_actions.legislative_parameters%type;

453: is
454: start_ptr number;
455: end_ptr number;
456: token_val pay_payroll_actions.legislative_parameters%type;
457: par_value pay_payroll_actions.legislative_parameters%type;
458: begin
459: --
460: token_val := name||'=';
461: --