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_PAYRG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 112: leg_param pay_payroll_actions.legislative_parameters%type;

108: --------------------------- range_cursor ---------------------------------
109: PROCEDURE range_cursor (pactid in number,
110: sqlstr out nocopy varchar2) is
111:
112: leg_param pay_payroll_actions.legislative_parameters%type;
113:
114: l_consolidation_set_id number;
115: l_payroll_id number;
116: l_organization_id number;

Line 130: from pay_payroll_actions ppa

126:
127: BEGIN
128: select legislative_parameters
129: into leg_param
130: from pay_payroll_actions ppa
131: where ppa.payroll_action_id = pactid;
132:
133: select ppa.legislative_parameters,
134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),

Line 151: from pay_payroll_actions ppa

147: l_person_id,
148: l_leg_start_date,
149: l_leg_end_date,
150: l_business_group_id
151: from pay_payroll_actions ppa
152: where ppa.payroll_action_id = pactid;
153:
154: IF l_consolidation_set_id is not null THEN
155:

Line 186: from pay_payroll_actions ppa,

182:
183:
184: sqlstr :=
185: 'select distinct asg.person_id
186: from pay_payroll_actions ppa,
187: pay_payroll_actions pa1,
188: pay_assignment_actions act,
189: per_assignments_f asg,
190: pay_payrolls_f ppf

Line 187: pay_payroll_actions pa1,

183:
184: sqlstr :=
185: 'select distinct asg.person_id
186: from pay_payroll_actions ppa,
187: pay_payroll_actions pa1,
188: pay_assignment_actions act,
189: per_assignments_f asg,
190: pay_payrolls_f ppf
191: where ppa.payroll_action_id = :payroll_action_id

Line 236: from pay_payroll_actions ppa

232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
234: ppa.start_date start_date,
235: ppa.effective_date effective_date
236: from pay_payroll_actions ppa
237: where ppa.payroll_action_id = pactid;
238:
239: cursor c_actions(
240: c_stperson number,

Line 261: pay_payroll_actions ppa, /* pre-payments and reversals

257: ppa.effective_date,
258: act.source_action_id,
259: nvl(ppa.start_date,ppa.effective_date)
260: from pay_payrolls_f ppf, -- Bug 3372747
261: pay_payroll_actions ppa, /* pre-payments and reversals
262: payroll action id */
263: pay_assignment_actions act,
264: per_assignments_f paf
265: where (c_payroll_id is NULL

Line 324: PAY_PAYROLL_ACTIONS PPA ,

320: from
321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,
322: PER_ASSIGNMENTS_F PAF ,
323: PAY_ASSIGNMENT_ACTIONS ACT ,
324: PAY_PAYROLL_ACTIONS PPA ,
325: PAY_PAYROLLS_F PPF
326: where (c_payroll_id is NULL
327: or ppa.payroll_id = c_payroll_id)
328:

Line 386: pay_payroll_actions ppa

382: select ppa.effective_date,
383: ppa.action_type
384: from pay_action_interlocks pai,
385: pay_assignment_actions paa,
386: pay_payroll_actions ppa
387: where pai.locking_action_id = cp_pre_pymt_action_id
388: and paa.assignment_action_id = pai.locked_action_id
389: and ppa.payroll_action_id = paa.payroll_action_id
390: and ppa.action_type in ('R', 'Q', 'B');

Line 396: pay_payroll_actions ppa

392: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
393: select assignment_action_id, ppa.action_type
394: from pay_action_interlocks pai,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa
397: where pai.locking_action_id = cp_pre_pymt_action_id
398: and paa.assignment_action_id = pai.locked_action_id
399: and ppa.payroll_action_id = paa.payroll_action_id
400: and ((paa.run_type_id is null and paa.source_action_id is null) or

Line 418: pay_payroll_actions ppa

414: cursor c_multi_ba_acts(cp_pre_pymt_action_id in number) is
415: select assignment_action_id, ppa.action_type
416: from pay_action_interlocks pai,
417: pay_assignment_actions paa,
418: pay_payroll_actions ppa
419: where pai.locking_action_id = cp_pre_pymt_action_id
420: and paa.assignment_action_id = pai.locked_action_id
421: and ppa.payroll_action_id = paa.payroll_action_id
422: and ((paa.run_type_id is null and paa.source_action_id is null) or

Line 460: pay_payroll_actions ppa,

456: select max(paa2.assignment_action_id)
457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
458: pay_assignment_actions paa1, -- assignment_action for master payroll run
459: pay_run_Types_f prt,
460: pay_payroll_actions ppa,
461: pay_action_interlocks pai
462: where pai.locking_action_id = cp_pre_pymt_action_id
463: and pai.locked_action_id = paa1.assignment_action_id
464: and paa1.source_action_id is null -- master assignment_action

Line 488: pay_payroll_actions ppa,

484: -- assignment_actions for slave payroll runs.
485: pay_assignment_actions paa1,
486: -- assignment_action for master payroll run
487: pay_run_Types_f prt,
488: pay_payroll_actions ppa,
489: pay_action_interlocks pai
490: where pai.locking_action_id = cp_pre_pymt_action_id
491: and pai.locked_action_id = paa1.assignment_action_id
492: and paa1.source_action_id is null -- master assignment_action

Line 507: pay_payroll_actions ppa

503: cursor c_check_for_void (cp_pre_pymt_action_id in number) is
504: select 'Y'
505: from pay_action_interlocks pai,
506: pay_assignment_actions paa,
507: pay_payroll_actions ppa
508: where pai.locking_action_id = cp_pre_pymt_action_id
509: and paa.assignment_action_id = pai.locked_action_id
510: and ppa.payroll_action_id = paa.payroll_action_id
511: and action_type = 'V';

Line 523: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;

519: actiontype VARCHAR2(1);
520: serialno VARCHAR2(30);
521:
522: -- Bug 3372747
523: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
524: l_asg_set_id number;
525: l_asg_flag VARCHAR2(10);
526: l_effective_date date;
527: l_start_date date;

Line 546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

542: l_asg_act_id number;
543: l_action_insert varchar2(1);
544: l_void_action varchar2(1);
545:
546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;

Line 548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

544: l_void_action varchar2(1);
545:
546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;

Line 554: cp_start_date pay_payroll_actions.effective_date%TYPE;

550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;
555: cp_effective_date pay_payroll_actions.effective_date%TYPE;
556:
557: l_run_eff_date date;
558: run_action_type VARCHAR2(30);

Line 555: cp_effective_date pay_payroll_actions.effective_date%TYPE;

551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;
555: cp_effective_date pay_payroll_actions.effective_date%TYPE;
556:
557: l_run_eff_date date;
558: run_action_type VARCHAR2(30);
559:

Line 571: from pay_payroll_actions ppa

567: hr_utility.set_location('procpyr',1);
568:
569: select legislative_parameters
570: into l_leg_param
571: from pay_payroll_actions ppa
572: where ppa.payroll_action_id = pactid;
573:
574: -- hr_utility.trace('Payroll Action ID = '||pactid);
575:

Line 1286: from pay_payroll_actions ppa

1282: pay_payrg_pkg.get_parameter('P_S3', ppa.legislative_parameters)
1283: into l_sort_1,
1284: l_sort_2,
1285: l_sort_3
1286: from pay_payroll_actions ppa
1287: where ppa.payroll_action_id = payactid;
1288:
1289:
1290: sqlstr :=

Line 1293: pay_payroll_actions ppa

1289:
1290: sqlstr :=
1291: 'select paa.rowid
1292: from pay_assignment_actions paa,
1293: pay_payroll_actions ppa
1294: where ppa.payroll_action_id = :payactid
1295: and paa.payroll_action_id = ppa.payroll_action_id
1296: order by
1297: (decode('''||l_sort_1||''',

Line 1337: from pay_payroll_actions ppa2,

1333: and ppa.effective_date between
1334: ppf.effective_start_date and ppf.effective_end_date
1335: ),
1336: (select ppa2.effective_date
1337: from pay_payroll_actions ppa2,
1338: pay_assignment_actions paa2
1339: where paa2.assignment_action_id = to_number(substr(paa.serial_number,4))
1340: and paa2.payroll_action_id = ppa2.payroll_action_id
1341: and ppa2.action_type in (''R'', ''Q'', ''V'', ''B'')

Line 1358: token_val pay_payroll_actions.legislative_parameters%type;

1354: RETURN VARCHAR2
1355: IS
1356: start_ptr number;
1357: end_ptr number;
1358: token_val pay_payroll_actions.legislative_parameters%type;
1359: par_value pay_payroll_actions.legislative_parameters%type;
1360: BEGIN
1361:
1362: token_val := name || '=';

Line 1359: par_value pay_payroll_actions.legislative_parameters%type;

1355: IS
1356: start_ptr number;
1357: end_ptr number;
1358: token_val pay_payroll_actions.legislative_parameters%type;
1359: par_value pay_payroll_actions.legislative_parameters%type;
1360: BEGIN
1361:
1362: token_val := name || '=';
1363: