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 132: leg_param pay_payroll_actions.legislative_parameters%type;

128: /*-- Bug#4942114 ends -- */
129:
130: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
131:
132: leg_param pay_payroll_actions.legislative_parameters%type;
133: l_consolidation_set_id number;
134: l_payroll_id number;
135: l_tax_unit_id number;
136: l_ppa_finder number;

Line 165: from pay_payroll_actions ppa

161: l_ppa_finder,
162: l_leg_start_date,
163: l_leg_end_date,
164: l_business_group_id
165: from pay_payroll_actions ppa
166: where ppa.payroll_action_id = pactid;
167:
168: IF l_payroll_id is not null THEN -- added to improve the performance
169: l_payroll_text := 'and ppa_run.payroll_id = ' || to_char(l_payroll_id) ;

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

182:
183: sqlstr := 'select distinct asg.person_id
184: from per_assignments_f asg,
185: pay_assignment_actions act_run, /* run and quickpay assignment actions */
186: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
187: pay_payroll_actions ppa_gen /* PYUGEN information */
188: where ppa_gen.payroll_action_id = :payroll_action_id
189: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */
190: ppa_gen.start_date and ppa_gen.effective_date

Line 187: pay_payroll_actions ppa_gen /* PYUGEN information */

183: sqlstr := 'select distinct asg.person_id
184: from per_assignments_f asg,
185: pay_assignment_actions act_run, /* run and quickpay assignment actions */
186: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
187: pay_payroll_actions ppa_gen /* PYUGEN information */
188: where ppa_gen.payroll_action_id = :payroll_action_id
189: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */
190: ppa_gen.start_date and ppa_gen.effective_date
191: and ppa_run.action_type in (''R'',''Q'',''V'')

Line 211: leg_param pay_payroll_actions.legislative_parameters%type;

207: stperson in number,
208: endperson in number,
209: chunk in number) is
210:
211: leg_param pay_payroll_actions.legislative_parameters%type;
212: l_consolidation_set_id number;
213: l_payroll_id number;
214: l_tax_unit_id number;
215:

Line 232: from pay_payroll_actions ppa

228: ppa.effective_date,
229: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
230: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
231: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
232: from pay_payroll_actions ppa
233: where ppa.payroll_action_id = pactid;
234:
235: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
236: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

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

232: from pay_payroll_actions ppa
233: where ppa.payroll_action_id = pactid;
234:
235: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
236: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.
237: CURSOR c_actions
238: (
239: pactid number,
240: stperson number,

Line 244: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)

240: stperson number,
241: endperson number
242: ) is
243: select /*+ ORDERED
244: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
245: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
246: INDEX (asg PER_ASSIGNMENTS_F_PK) */
247: ppa_run.action_type,
248: act_run.assignment_action_id,

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

247: ppa_run.action_type,
248: act_run.assignment_action_id,
249: asg.assignment_id,
250: act_run.tax_unit_id
251: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
252: pay_assignment_actions act_run, /* run and quickpay assignment actions */
253: per_assignments_f asg
254: where ppa_run.effective_date between
255: l_start_date

Line 417: leg_param pay_payroll_actions.legislative_parameters%type;

413: stperson in number,
414: endperson in number,
415: chunk in number) is
416:
417: leg_param pay_payroll_actions.legislative_parameters%type;
418: l_consolidation_set_id number;
419: l_payroll_id number;
420: l_tax_unit_id number;
421:

Line 438: from pay_payroll_actions ppa

434: ppa.effective_date,
435: pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
436: pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
437: pay_paygtn_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
438: from pay_payroll_actions ppa
439: where ppa.payroll_action_id = pactid;
440:
441: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
442: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.

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

438: from pay_payroll_actions ppa
439: where ppa.payroll_action_id = pactid;
440:
441: --Bug 3364759 --Used the local variables l_business_group_id,l_start_date,l_effective_date in the
442: -- cursor query to reduce its cost.Also removed the forced index PAY_PAYROLL_ACTIONS_N5.
443: CURSOR c_actions
444: (
445: pactid number,
446: stperson number,

Line 450: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)

446: stperson number,
447: endperson number
448: ) is
449: select /*+ ORDERED
450: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
451: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
452: INDEX (asg PER_ASSIGNMENTS_F_PK) */
453: ppa_run.action_type,
454: act_run.assignment_action_id,

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

453: ppa_run.action_type,
454: act_run.assignment_action_id,
455: asg.assignment_id,
456: act_run.tax_unit_id
457: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
458: pay_assignment_actions act_run, /* run and quickpay assignment actions */
459: per_assignments_f asg
460: where ppa_run.effective_date between
461: l_start_date

Line 622: pay_payroll_actions ppa1 -- PYUGEN payroll action id

618: begin
619:
620: sqlstr := 'select paa1.rowid
621: from pay_assignment_actions paa1, -- PYUGEN assignment action
622: pay_payroll_actions ppa1 -- PYUGEN payroll action id
623: where ppa1.payroll_action_id = :pactid
624: and paa1.payroll_action_id = ppa1.payroll_action_id
625: order by paa1.assignment_action_id
626: for update of paa1.assignment_id';

Line 636: token_val pay_payroll_actions.legislative_parameters%type;

632: parameter_list varchar2) return varchar2
633: is
634: start_ptr number;
635: end_ptr number;
636: token_val pay_payroll_actions.legislative_parameters%type;
637: par_value pay_payroll_actions.legislative_parameters%type;
638: begin
639: --
640: token_val := name||'=';

Line 637: par_value pay_payroll_actions.legislative_parameters%type;

633: is
634: start_ptr number;
635: end_ptr number;
636: token_val pay_payroll_actions.legislative_parameters%type;
637: par_value pay_payroll_actions.legislative_parameters%type;
638: begin
639: --
640: token_val := name||'=';
641: --

Line 738: from pay_payroll_actions ppa

734: into l_param,
735: p_business_group_id,
736: p_start_date,
737: p_end_date
738: from pay_payroll_actions ppa
739: where ppa.payroll_action_id = p_payroll_action_id;
740:
741: g_payroll_action_id := p_payroll_action_id;
742: p_consolidation_set_id := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);

Line 991: FROM pay_payroll_actions

987:
988: -- Get request_id
989: CURSOR get_request_id (c_pact_id NUMBER)IS
990: SELECT request_id
991: FROM pay_payroll_actions
992: WHERE payroll_action_id = c_pact_id;
993:
994: -- Get Application Short Name and Application ID
995: CURSOR get_application_detais(c_request_id NUMBER) IS