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 72: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

68: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
69:
70:
71: l_assign_year number;
72: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
73: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
74: begin
75:
76: /* EOY reg code */

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

96: pay_yrend_reports_pkg.get_parameter
97: ('TRANSFER_GRE',ppa.legislative_parameters);
98:
99: sqlstr := 'select distinct to_number(act.serial_number)
100: from pay_assignment_actions act /* W2 Register Information */
101: where :pactid is not null
102: and act.payroll_action_id = ' || l_eoy_payroll_action_id ||
103: ' and act.tax_unit_id = ' || l_tax_unit_id ||
104: ' order by to_number(act.serial_number)';

Line 125: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,

121: pactid number,
122: stperson number,
123: endperson number,
124: c_assign_year number,
125: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
126: c_assign_set hr_assignment_set_amendments.assignment_set_id%type,
127: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type
128: ) is
129: select act.assignment_action_id,

Line 134: from pay_assignment_actions act

130: act.assignment_id,
131: act.tax_unit_id,
132: to_number(act.serial_number)
133: -- need to select person id to check for assignment set
134: from pay_assignment_actions act
135: where act.payroll_action_id = c_eoy_payroll_action_id
136: and act.tax_unit_id = c_tax_unit_id
137: and to_number(act.serial_number) between stperson and endperson
138: and exists ( select 1

Line 156: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,

152: pactid number,
153: stperson number,
154: endperson number,
155: c_assign_year number,
156: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
157: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type,
158: c_effective_date pay_payroll_actions.effective_date%TYPE,
159: c_start_date pay_payroll_actions.start_date%TYPE
160: ) is

Line 166: from pay_assignment_actions act,

162: act.assignment_id,
163: act.tax_unit_id,
164: to_number(act.serial_number)
165: -- need to select person id to check for assignment set
166: from pay_assignment_actions act,
167: per_assignments_f paf
168: where act.payroll_action_id = c_eoy_payroll_action_id
169: and act.tax_unit_id = c_tax_unit_id
170: and paf.assignment_id = act.assignment_id

Line 189: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

185: num number;
186: p_person_id number;
187: l_assign_set number;
188: l_assign_year number;
189: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
190: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
191:
192: l_effective_date pay_payroll_actions.effective_date%TYPE;
193: l_start_date pay_payroll_actions.start_date%TYPE;

Line 281: select pay_assignment_actions_s.nextval

277: -- we need to insert one action for each of the
278: -- rows that we return from the cursor (i.e. one
279: -- for each assignment/pre-payment/reversal).
280:
281: select pay_assignment_actions_s.nextval
282: into lockingactid
283: from dual;
284:
285: hr_utility.set_location(l_procedure_name, 30);

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

285: hr_utility.set_location(l_procedure_name, 30);
286: -- insert the action record.
287: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
288:
289: /* update pay_assignment_actions with the year end assignment_actions into serial number
290: this might help in faster processing at report level and avoid some joins */
291:
292: update pay_assignment_actions
293: set serial_number = lockedactid

Line 292: update pay_assignment_actions

288:
289: /* update pay_assignment_actions with the year end assignment_actions into serial number
290: this might help in faster processing at report level and avoid some joins */
291:
292: update pay_assignment_actions
293: set serial_number = lockedactid
294: where assignment_action_id = lockingactid;
295:
296:

Line 325: from pay_assignment_actions act,

321: act.assignment_id,
322: act.tax_unit_id,
323: to_number(act.serial_number)
324: -- need to select person id to check for assignment set
325: from pay_assignment_actions act,
326: per_assignments_f paf
327: where act.payroll_action_id = ' || l_eoy_payroll_action_id || '
328: and act.tax_unit_id = ' || l_tax_unit_id || '
329: and paf.assignment_id = act.assignment_id

Line 485: select pay_assignment_actions_s.nextval

481: exit;
482: end if;
483:
484: hr_utility.set_location(l_procedure_name, 160);
485: select pay_assignment_actions_s.nextval
486: into lockingactid
487: from dual;
488:
489: -- insert the action record.

Line 492: update pay_assignment_actions

488:
489: -- insert the action record.
490: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
491:
492: update pay_assignment_actions
493: set serial_number = lockedactid
494: where assignment_action_id = lockingactid;
495:
496: end loop;

Line 519: select pay_assignment_actions_s.nextval

515: -- rows that we return from the cursor (i.e. one
516: -- for each assignment/pre-payment/reversal).
517:
518: hr_utility.set_location(l_procedure_name, 180);
519: select pay_assignment_actions_s.nextval
520: into lockingactid
521: from dual;
522:
523: -- insert the action record.

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

522:
523: -- insert the action record.
524: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
525:
526: /* update pay_assignment_actions with the year end assignment_actions into serial number
527: this might help in faster processing at report level and avoid some joins */
528:
529: update pay_assignment_actions
530: set serial_number = lockedactid

Line 529: update pay_assignment_actions

525:
526: /* update pay_assignment_actions with the year end assignment_actions into serial number
527: this might help in faster processing at report level and avoid some joins */
528:
529: update pay_assignment_actions
530: set serial_number = lockedactid
531: where assignment_action_id = lockingactid;
532:
533:

Line 556: l_gre_id pay_assignment_actions.tax_unit_id%type;

552: ) is
553:
554: l_dt date;
555: l_year number ;
556: l_gre_id pay_assignment_actions.tax_unit_id%type;
557: l_org_id per_assignments_f.organization_id%type;
558: l_loc_id per_assignments_f.location_id%type;
559: l_per_id per_assignments_f.person_id%type;
560: l_ssn per_people_f.national_identifier%type;

Line 610: /pay_assignment_actions paa,/

606: from hr_all_organization_units hou,
607: hr_locations_all loc,
608: per_all_people_f ppf, -- #1894165
609: per_all_assignments_f paf,
610: /*pay_assignment_actions paa,*/
611: pay_payroll_actions ppa1,
612: pay_assignment_actions paa1 /* PYUGEN assignment action */
613: where ppa1.payroll_action_id = :pactid
614: and paa1.payroll_action_id = ppa1.payroll_action_id

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

608: per_all_people_f ppf, -- #1894165
609: per_all_assignments_f paf,
610: /*pay_assignment_actions paa,*/
611: pay_payroll_actions ppa1,
612: pay_assignment_actions paa1 /* PYUGEN assignment action */
613: where ppa1.payroll_action_id = :pactid
614: and paa1.payroll_action_id = ppa1.payroll_action_id
615: and paf.assignment_id = paa1.assignment_id
616: and paf.effective_start_date =