APPS.PAY_US_OVER_LIMIT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 72: leg_param pay_payroll_actions.legislative_parameters%type;

68: -------------------- range_cursor ---------------------------------------------
69: --
70: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
71: --
72: leg_param pay_payroll_actions.legislative_parameters%type;
73: l_gre_id number;
74: l_loc_id number;
75: l_org_id number;
76: l_as_of_date varchar2(240);

Line 77: l_bg_id pay_payroll_actions.business_group_id%type;

73: l_gre_id number;
74: l_loc_id number;
75: l_org_id number;
76: l_as_of_date varchar2(240);
77: l_bg_id pay_payroll_actions.business_group_id%type;
78: where_condition varchar(5000);
79:
80: --
81: --

Line 99: from pay_payroll_actions ppa

95: l_gre_id,
96: l_org_id,
97: l_loc_id,
98: l_as_of_date
99: from pay_payroll_actions ppa
100: where ppa.payroll_action_id = pactid;
101: exception
102: when others then
103: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

Line 123: index(ppa PAY_PAYROLL_ACTIONS_N5)

119: hr_utility.trace('l_as_of_date='||l_as_of_date);
120: hr_utility.trace('l_bg_id='||l_bg_id);
121:
122: sqlstr := 'select /*+ ORDERED
123: index(ppa PAY_PAYROLL_ACTIONS_N5)
124: index(paa PAY_ASSIGNMENT_ACTIONS_N50)
125: index(paf per_assignments_pk) */
126: distinct paf.person_id
127: from

Line 128: pay_payroll_actions ppa,

124: index(paa PAY_ASSIGNMENT_ACTIONS_N50)
125: index(paf per_assignments_pk) */
126: distinct paf.person_id
127: from
128: pay_payroll_actions ppa,
129: pay_assignment_actions paa,
130: per_assignments_f paf
131: where :payroll_action_id is not null
132: and paa.payroll_action_id = ppa.payroll_action_id

Line 154: leg_param pay_payroll_actions.legislative_parameters%type;

150: stperson in number,
151: endperson in number,
152: chunk in number) is
153:
154: leg_param pay_payroll_actions.legislative_parameters%type;
155: action_type varchar2(30);
156: l_as_of_date varchar2(240);
157: -- l_date_prm varchar2(50);
158: l_gre_id pay_assignment_actions.tax_unit_id%type;

Line 193: from pay_payroll_actions ppa

189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa
194: where ppa.payroll_action_id = pactid;
195:
196: l_prev_person_id per_people_f.person_id%type;
197: l_prev_tu_id pay_assignment_actions.tax_unit_id%type;

Line 246: pay_payroll_actions ppa,

242: select /*+ ORDERED */
243: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id -- Bug 5717518
244: from per_all_assignments_f paf,
245: pay_assignment_actions paa,
246: pay_payroll_actions ppa,
247: pay_action_classifications pac
248: where paf.assignment_id = cp_assignid -- Bug 5717518: New parameter added for performance improvement
249: and paf.person_id = cp_person_id -- Bug 5717518: Shuffled the Where Clause for performance improvement
250: and paa.assignment_id = paf.assignment_id

Line 352: pay_payroll_actions ppa,

348: paf.assignment_id,
349: paa.tax_unit_id
350: from per_assignments_f paf,
351: pay_assignment_actions paa,
352: pay_payroll_actions ppa,
353: PAY_POPULATION_RANGES ppr
354: where ppr.payroll_action_id = '|| pactid ||'
355: and ppr.chunk_number = '|| chunk ||'
356: and paf.person_id = ppr.person_id

Line 391: index(ppa PAY_PAYROLL_ACTIONS_PK)

387: hr_utility.trace('lv_where_condition :'||lv_where_condition) ;
388:
389: lv_sqlstr := 'select
390: /*+ ORDERED
391: index(ppa PAY_PAYROLL_ACTIONS_PK)
392: index(paa PAY_ASSIGNMENT_ACTIONS_N51)
393: index(paf PER_ASSIGNMENTS_N12) */
394: distinct paf.person_id person_id,
395: paf.assignment_id,

Line 399: pay_payroll_actions ppa

395: paf.assignment_id,
396: paa.tax_unit_id
397: from per_assignments_f paf,
398: pay_assignment_actions paa,
399: pay_payroll_actions ppa
400: where paf.person_id between '|| stperson ||' and '|| endperson ||'
401: and paf.assignment_type = ''E''
402: and paa.assignment_id = paf.assignment_id
403: and ppa.payroll_action_id = paa.payroll_action_id

Line 454: leg_param pay_payroll_actions.legislative_parameters%type;

450: sqlstr in out nocopy varchar2, /* string holding the sql statement */
451: len out nocopy number /* length of the sql string */
452: ) is
453: --
454: leg_param pay_payroll_actions.legislative_parameters%type;
455: l_sort1 varchar2(60);
456: l_sort2 varchar2(60);
457: l_sort3 varchar2(60);
458:

Line 465: from pay_payroll_actions ppa

461: ppa.legislative_parameters,
462: pay_us_payroll_utils.get_parameter('SORT1',ppa.legislative_parameters),
463: pay_us_payroll_utils.get_parameter('SORT2',ppa.legislative_parameters),
464: pay_us_payroll_utils.get_parameter('SORT3',ppa.legislative_parameters)
465: from pay_payroll_actions ppa
466: where ppa.payroll_action_id = pactid;
467: --
468: begin
469: hr_utility.set_location('IN sort_action',400);

Line 485: FROM pay_payroll_actions ppa,

481: --
482:
483: sqlstr :=
484: 'SELECT paa.rowid
485: FROM pay_payroll_actions ppa,
486: pay_assignment_actions paa,
487: per_all_assignments_f paf,
488: per_all_people_f ppf,
489: hr_organization_units hou,

Line 534: token_val pay_payroll_actions.legislative_parameters%type;

530: parameter_list varchar2) return varchar2
531: is
532: start_ptr number;
533: end_ptr number;
534: token_val pay_payroll_actions.legislative_parameters%type;
535: par_value pay_payroll_actions.legislative_parameters%type;
536: begin
537: --
538: token_val := name||'=';

Line 535: par_value pay_payroll_actions.legislative_parameters%type;

531: is
532: start_ptr number;
533: end_ptr number;
534: token_val pay_payroll_actions.legislative_parameters%type;
535: par_value pay_payroll_actions.legislative_parameters%type;
536: begin
537: --
538: token_val := name||'=';
539: --