eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_YREND_REPORTS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 30: pay_assignment_actions instead of per_all_assignments_f

26: 24-DEC-2001 meshah 115.8 Changed hr_locations to hr_locations_all.
27: 06-JAN-2002 meshah 115.9 inlcuded a space in range cursor while
28: constructing the sqlstr.
29: 11-SEP-2002 ppanda 115.10 Sort cursor sql string changed to use
30: pay_assignment_actions instead of per_all_assignments_f
31: in for update clause
32:
33: 09-JAN-2003 ahanda 115.13 Sort cursor changed ti Fix Bug 2743186
34: 09-JAN-2003 asasthan 115.14 nocopy changes

Line 75: l_tax_unit_id pay_assignment_actions.tax_unit_id%type

71: /* Bug : 10254849 */
72: CURSOR get_person_id_debug
73: ( pactid number,
74: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
75: l_tax_unit_id pay_assignment_actions.tax_unit_id%type
76: ) is
77: select distinct to_number(act.serial_number),act.assignment_id
78: from pay_assignment_actions act /* W2 Register Information */
79: where pactid is not null

Line 78: from pay_assignment_actions act /* W2 Register Information */

74: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
75: l_tax_unit_id pay_assignment_actions.tax_unit_id%type
76: ) is
77: select distinct to_number(act.serial_number),act.assignment_id
78: from pay_assignment_actions act /* W2 Register Information */
79: where pactid is not null
80: and act.payroll_action_id = l_eoy_payroll_action_id
81: and act.tax_unit_id = l_tax_unit_id
82: order by to_number(act.serial_number);

Line 87: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

83: person_id number;
84: assignment_id number;
85: num number;
86: l_assign_year number;
87: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
88: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
89: begin
90:
91: /* EOY reg code */

Line 115: from pay_assignment_actions act /* W2 Register Information */

111: pay_yrend_reports_pkg.get_parameter
112: ('TRANSFER_GRE',ppa.legislative_parameters);
113:
114: sqlstr := 'select distinct to_number(act.serial_number)
115: from pay_assignment_actions act /* W2 Register Information */
116: where :pactid is not null
117: and act.payroll_action_id = ' || l_eoy_payroll_action_id ||
118: ' and act.tax_unit_id = ' || l_tax_unit_id ||
119: ' order by to_number(act.serial_number)';

Line 154: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,

150: pactid number,
151: stperson number,
152: endperson number,
153: c_assign_year number,
154: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
155: c_assign_set hr_assignment_set_amendments.assignment_set_id%type,
156: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type
157: ) is
158: select act.assignment_action_id,

Line 163: from pay_assignment_actions act

159: act.assignment_id,
160: act.tax_unit_id,
161: to_number(act.serial_number)
162: -- need to select person id to check for assignment set
163: from pay_assignment_actions act
164: where act.payroll_action_id = c_eoy_payroll_action_id
165: and act.tax_unit_id = c_tax_unit_id
166: and to_number(act.serial_number) between stperson and endperson
167: and exists ( select 1

Line 185: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,

181: pactid number,
182: stperson number,
183: endperson number,
184: c_assign_year number,
185: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
186: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
187: c_effective_date pay_payroll_actions.effective_date%TYPE,
188: c_start_date pay_payroll_actions.start_date%TYPE
189: ) is

Line 195: from pay_assignment_actions act,

191: act.assignment_id,
192: act.tax_unit_id,
193: to_number(act.serial_number)
194: -- need to select person id to check for assignment set
195: from pay_assignment_actions act,
196: per_assignments_f paf
197: where act.payroll_action_id = c_eoy_payroll_action_id
198: and act.tax_unit_id = c_tax_unit_id
199: and paf.assignment_id = act.assignment_id

Line 218: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

214: num number;
215: p_person_id number;
216: l_assign_set number;
217: l_assign_year number;
218: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
219: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
220:
221: l_effective_date pay_payroll_actions.effective_date%TYPE;
222: l_start_date pay_payroll_actions.start_date%TYPE;

Line 314: select pay_assignment_actions_s.nextval

310: -- we need to insert one action for each of the
311: -- rows that we return from the cursor (i.e. one
312: -- for each assignment/pre-payment/reversal).
313:
314: select pay_assignment_actions_s.nextval
315: into lockingactid
316: from dual;
317:
318: hr_utility.set_location(l_procedure_name, 30);

Line 322: /* update pay_assignment_actions with the year end assignment_actions into serial number

318: hr_utility.set_location(l_procedure_name, 30);
319: -- insert the action record.
320: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
321:
322: /* update pay_assignment_actions with the year end assignment_actions into serial number
323: this might help in faster processing at report level and avoid some joins */
324:
325: update pay_assignment_actions
326: set serial_number = lockedactid

Line 325: update pay_assignment_actions

321:
322: /* update pay_assignment_actions with the year end assignment_actions into serial number
323: this might help in faster processing at report level and avoid some joins */
324:
325: update pay_assignment_actions
326: set serial_number = lockedactid
327: where assignment_action_id = lockingactid;
328:
329:

Line 358: from pay_assignment_actions act,

354: act.assignment_id,
355: act.tax_unit_id,
356: to_number(act.serial_number)
357: -- need to select person id to check for assignment set
358: from pay_assignment_actions act,
359: per_assignments_f paf
360: where act.payroll_action_id = ' || l_eoy_payroll_action_id || '
361: and act.tax_unit_id = ' || l_tax_unit_id || '
362: and paf.assignment_id = act.assignment_id

Line 518: select pay_assignment_actions_s.nextval

514: if g_debug then
515: hr_utility.trace(' [ ACTION CREATION CODE, STATE CODE AS INPUT PARAM ] PERSON ID :' || p_person_id || ' ASSIGNMENT ID:' || assignid);
516: end if;
517: hr_utility.set_location(l_procedure_name, 160);
518: select pay_assignment_actions_s.nextval
519: into lockingactid
520: from dual;
521:
522: -- insert the action record.

Line 525: update pay_assignment_actions

521:
522: -- insert the action record.
523: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
524:
525: update pay_assignment_actions
526: set serial_number = lockedactid
527: where assignment_action_id = lockingactid;
528:
529: end loop;

Line 557: select pay_assignment_actions_s.nextval

553: -- rows that we return from the cursor (i.e. one
554: -- for each assignment/pre-payment/reversal).
555:
556: hr_utility.set_location(l_procedure_name, 180);
557: select pay_assignment_actions_s.nextval
558: into lockingactid
559: from dual;
560:
561: -- insert the action record.

Line 564: /* update pay_assignment_actions with the year end assignment_actions into serial number

560:
561: -- insert the action record.
562: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
563:
564: /* update pay_assignment_actions with the year end assignment_actions into serial number
565: this might help in faster processing at report level and avoid some joins */
566:
567: update pay_assignment_actions
568: set serial_number = lockedactid

Line 567: update pay_assignment_actions

563:
564: /* update pay_assignment_actions with the year end assignment_actions into serial number
565: this might help in faster processing at report level and avoid some joins */
566:
567: update pay_assignment_actions
568: set serial_number = lockedactid
569: where assignment_action_id = lockingactid;
570:
571:

Line 594: l_gre_id pay_assignment_actions.tax_unit_id%type;

590: ) is
591:
592: l_dt date;
593: l_year number ;
594: l_gre_id pay_assignment_actions.tax_unit_id%type;
595: l_org_id per_assignments_f.organization_id%type;
596: l_loc_id per_assignments_f.location_id%type;
597: l_per_id per_assignments_f.person_id%type;
598: l_ssn per_people_f.national_identifier%type;

Line 648: /pay_assignment_actions paa,/

644: from hr_all_organization_units hou,
645: hr_locations_all loc,
646: per_all_people_f ppf, -- #1894165
647: per_all_assignments_f paf,
648: /*pay_assignment_actions paa,*/
649: pay_payroll_actions ppa1,
650: pay_assignment_actions paa1 /* PYUGEN assignment action */
651: where ppa1.payroll_action_id = :pactid
652: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 650: pay_assignment_actions paa1 /* PYUGEN assignment action */

646: per_all_people_f ppf, -- #1894165
647: per_all_assignments_f paf,
648: /*pay_assignment_actions paa,*/
649: pay_payroll_actions ppa1,
650: pay_assignment_actions paa1 /* PYUGEN assignment action */
651: where ppa1.payroll_action_id = :pactid
652: and paa1.payroll_action_id = ppa1.payroll_action_id
653: and paf.assignment_id = paa1.assignment_id
654: and paf.effective_start_date =