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

Line 138: leg_param pay_payroll_actions.legislative_parameters%type;

134: /*-- Bug#4942114 ends -- */
135:
136: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
137:
138: leg_param pay_payroll_actions.legislative_parameters%type;
139: l_consolidation_set_id number;
140: l_payroll_id number;
141: l_tax_unit_id number;
142: l_ppa_finder number;

Line 171: from pay_payroll_actions ppa

167: l_ppa_finder,
168: l_leg_start_date,
169: l_leg_end_date,
170: l_business_group_id
171: from pay_payroll_actions ppa
172: where ppa.payroll_action_id = pactid;
173:
174: IF l_payroll_id is not null THEN -- added to improve the performance
175: l_payroll_text := 'and ppa_run.payroll_id = ' || to_char(l_payroll_id) ;

Line 195: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

191:
192: sqlstr := 'select distinct asg.person_id
193: from per_assignments_f asg,
194: pay_assignment_actions act_run, /* run and quickpay assignment actions */
195: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
196: pay_payroll_actions ppa_gen /* PYUGEN information */
197: where ppa_gen.payroll_action_id = :payroll_action_id
198: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */
199: ppa_gen.start_date and ppa_gen.effective_date

Line 196: pay_payroll_actions ppa_gen /* PYUGEN information */

192: sqlstr := 'select distinct asg.person_id
193: from per_assignments_f asg,
194: pay_assignment_actions act_run, /* run and quickpay assignment actions */
195: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
196: pay_payroll_actions ppa_gen /* PYUGEN information */
197: where ppa_gen.payroll_action_id = :payroll_action_id
198: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */
199: ppa_gen.start_date and ppa_gen.effective_date
200: and ppa_run.action_type in (''R'',''Q'',''V'',''B'',''I'')

Line 220: leg_param pay_payroll_actions.legislative_parameters%type;

216: stperson in number,
217: endperson in number,
218: chunk in number) is
219:
220: leg_param pay_payroll_actions.legislative_parameters%type;
221: l_consolidation_set_id number;
222: l_payroll_id number;
223: l_tax_unit_id number;
224:

Line 241: from pay_payroll_actions ppa

237: ppa.effective_date,
238: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
239: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
240: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
241: from pay_payroll_actions ppa
242: where ppa.payroll_action_id = pactid;
243:
244: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
245: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

Line 245: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

241: from pay_payroll_actions ppa
242: where ppa.payroll_action_id = pactid;
243:
244: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
245: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.
246: CURSOR c_actions
247: (
248: pactid number,
249: stperson number,

Line 253: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)

249: stperson number,
250: endperson number
251: ) is
252: select /*+ ORDERED
253: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
254: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
255: INDEX (asg PER_ASSIGNMENTS_F_PK) */
256: ppa_run.action_type,
257: act_run.assignment_action_id,

Line 260: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

256: ppa_run.action_type,
257: act_run.assignment_action_id,
258: asg.assignment_id,
259: act_run.tax_unit_id
260: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
261: pay_assignment_actions act_run, /* run and quickpay assignment actions */
262: per_assignments_f asg
263: where ppa_run.effective_date between
264: l_start_date

Line 426: leg_param pay_payroll_actions.legislative_parameters%type;

422: stperson in number,
423: endperson in number,
424: chunk in number) is
425:
426: leg_param pay_payroll_actions.legislative_parameters%type;
427: l_consolidation_set_id number;
428: l_payroll_id number;
429: l_tax_unit_id number;
430:

Line 447: from pay_payroll_actions ppa

443: ppa.effective_date,
444: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
445: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
446: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
447: from pay_payroll_actions ppa
448: where ppa.payroll_action_id = pactid;
449:
450: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
451: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

Line 451: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

447: from pay_payroll_actions ppa
448: where ppa.payroll_action_id = pactid;
449:
450: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
451: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.
452: CURSOR c_actions
453: (
454: pactid number,
455: stperson number,

Line 459: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)

455: stperson number,
456: endperson number
457: ) is
458: select /*+ ORDERED
459: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
460: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
461: INDEX (asg PER_ASSIGNMENTS_F_PK) */
462: ppa_run.action_type,
463: act_run.assignment_action_id,

Line 466: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */

462: ppa_run.action_type,
463: act_run.assignment_action_id,
464: asg.assignment_id,
465: act_run.tax_unit_id
466: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
467: pay_assignment_actions act_run, /* run and quickpay assignment actions */
468: per_assignments_f asg
469: where ppa_run.effective_date between
470: l_start_date

Line 631: pay_payroll_actions ppa1 -- PYUGEN payroll action id

627: begin
628:
629: sqlstr := 'select paa1.rowid
630: from pay_assignment_actions paa1, -- PYUGEN assignment action
631: pay_payroll_actions ppa1 -- PYUGEN payroll action id
632: where ppa1.payroll_action_id = :pactid
633: and paa1.payroll_action_id = ppa1.payroll_action_id
634: order by paa1.assignment_action_id
635: for update of paa1.assignment_id';

Line 645: token_val pay_payroll_actions.legislative_parameters%type;

641: parameter_list varchar2) return varchar2
642: is
643: start_ptr number;
644: end_ptr number;
645: token_val pay_payroll_actions.legislative_parameters%type;
646: par_value pay_payroll_actions.legislative_parameters%type;
647: begin
648: --
649: token_val := name||'=';

Line 646: par_value pay_payroll_actions.legislative_parameters%type;

642: is
643: start_ptr number;
644: end_ptr number;
645: token_val pay_payroll_actions.legislative_parameters%type;
646: par_value pay_payroll_actions.legislative_parameters%type;
647: begin
648: --
649: token_val := name||'=';
650: --

Line 747: from pay_payroll_actions ppa

743: into l_param,
744: p_business_group_id,
745: p_start_date,
746: p_end_date
747: from pay_payroll_actions ppa
748: where ppa.payroll_action_id = p_payroll_action_id;
749:
750: g_payroll_action_id := p_payroll_action_id;
751: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);

Line 1000: FROM pay_payroll_actions

996:
997: -- Get request_id
998: CURSOR get_request_id (c_pact_id NUMBER)IS
999: SELECT request_id
1000: FROM pay_payroll_actions
1001: WHERE payroll_action_id = c_pact_id;
1002:
1003: -- Get Application Short Name and Application ID
1004: CURSOR get_application_detais(c_request_id NUMBER) IS