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.PYUSDAR_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 142: leg_param pay_payroll_actions.legislative_parameters%type;

138: ----------------------------------- range_cursor ----------------------------------
139: --
140: procedure range_cursor (pactid in number, sqlstr out NOCOPY varchar2) is
141: l_payroll_id number;
142: leg_param pay_payroll_actions.legislative_parameters%type;
143:
144: --Bug 3331028
145: l_db_version varchar2(20);
146: --

Line 151: from pay_payroll_actions ppa

147:
148: begin
149: select legislative_parameters
150: into leg_param
151: from pay_payroll_actions ppa
152: where ppa.payroll_action_id = pactid;
153: --
154: l_payroll_id := pyusdar_pkg.get_parameter('PAYROLL_ID', leg_param);
155: --

Line 170: pay_payroll_actions pa2,

166: sqlstr := 'select '||l_db_version||' distinct pos.person_id
167: from pay_assignment_actions act,
168: per_assignments_f asg,
169: per_periods_of_service pos,
170: pay_payroll_actions pa2,
171: pay_payroll_actions pa1
172: where pa1.payroll_action_id = :payroll_action_id
173: and pa2.action_type in (''R'',''Q'')
174: and pa2.consolidation_set_id =

Line 171: pay_payroll_actions pa1

167: from pay_assignment_actions act,
168: per_assignments_f asg,
169: per_periods_of_service pos,
170: pay_payroll_actions pa2,
171: pay_payroll_actions pa1
172: where pa1.payroll_action_id = :payroll_action_id
173: and pa2.action_type in (''R'',''Q'')
174: and pa2.consolidation_set_id =
175: pyusdar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

Line 197: pay_payroll_actions pa2,

193: sqlstr := 'select '||l_db_version||' distinct pos.person_id
194: from pay_assignment_actions act,
195: per_assignments_f asg,
196: per_periods_of_service pos,
197: pay_payroll_actions pa2,
198: pay_payroll_actions pa1
199: where pa1.payroll_action_id = :payroll_action_id
200: and pa2.consolidation_set_id =
201: pyusdar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

Line 198: pay_payroll_actions pa1

194: from pay_assignment_actions act,
195: per_assignments_f asg,
196: per_periods_of_service pos,
197: pay_payroll_actions pa2,
198: pay_payroll_actions pa1
199: where pa1.payroll_action_id = :payroll_action_id
200: and pa2.consolidation_set_id =
201: pyusdar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
202: pa1.legislative_parameters)

Line 242: pay_payroll_actions ppa_dar,

238: from pay_assignment_actions act,
239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,
243: pay_payroll_actions ppa_mag_pmts,
244: pay_payrolls_f pay --Bug 3343621
245: where ( ppa_dar.payroll_action_id = pactid
246: and ppa_mag_pmts.consolidation_set_id +0

Line 243: pay_payroll_actions ppa_mag_pmts,

239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,
243: pay_payroll_actions ppa_mag_pmts,
244: pay_payrolls_f pay --Bug 3343621
245: where ( ppa_dar.payroll_action_id = pactid
246: and ppa_mag_pmts.consolidation_set_id +0
247: = pyusdar_pkg.get_parameter('CONSOLIDATION_SET_ID',

Line 287: pay_payroll_actions ppa_run, --- RUN

283: Select ''
284: from pay_action_interlocks int2,
285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
289: pay_assignment_actions paa_run --- RUN
290: where
291: int2.locking_action_id = act.assignment_action_id -- prepayment action

Line 288: pay_payroll_actions pact4, --- Reversal

284: from pay_action_interlocks int2,
285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
289: pay_assignment_actions paa_run --- RUN
290: where
291: int2.locking_action_id = act.assignment_action_id -- prepayment action
292: and int2.locked_action_id = paa_run.assignment_action_id

Line 379: pay_payroll_actions ppa_dar,

375: from pay_assignment_actions act,
376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,
381: pay_org_payment_methods_f popm --Bug 3009643
382: where ppa_dar.payroll_action_id = :pactid
383: and ppa_mag.consolidation_set_id +0 =

Line 380: pay_payroll_actions ppa_mag,

376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,
381: pay_org_payment_methods_f popm --Bug 3009643
382: where ppa_dar.payroll_action_id = :pactid
383: and ppa_mag.consolidation_set_id +0 =
384: pyusdar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

Line 416: pay_payroll_actions ppa_run, --- RUN

412: Select ''''
413: from pay_action_interlocks int2,
414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
419: pay_assignment_actions paa_pp --- PREPAY
420: where

Line 417: pay_payroll_actions pact4, --- Reversal

413: from pay_action_interlocks int2,
414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
419: pay_assignment_actions paa_pp --- PREPAY
420: where
421: int3.locked_action_id = act.assignment_action_id

Line 602: pay_payroll_actions ppa_dar,

598: paa_xfr.assignment_action_id,
599: paa_xfr.assignment_id,
600: paa_xfr.tax_unit_id
601: from per_assignments_f paf,
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,

Line 603: pay_payroll_actions ppa_run,

599: paa_xfr.assignment_id,
600: paa_xfr.tax_unit_id
601: from per_assignments_f paf,
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,

Line 608: pay_payroll_actions ppa_xfr

604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,
608: pay_payroll_actions ppa_xfr
609: , pay_payrolls_f pay -- #2264358
610: where ppa_dar.payroll_action_id = pactid
611: and ppa_xfr.report_type = 'XFR_INTERFACE'
612: and ppa_dar.effective_date between ppa_xfr.start_date

Line 665: pay_payroll_actions ppa_mag

661: /* XFR => PRE */
662: and exists ( select 'Y'
663: from pay_action_interlocks pai_mag,
664: pay_assignment_actions paa_mag,
665: pay_payroll_actions ppa_mag
666: where pai_mag.locked_action_id = pai_pre.locked_action_id
667: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
668: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id
669: and ppa_mag.action_type = 'M'

Line 693: pay_payroll_actions ppa_run, --- RUN

689: Select ''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run --- RUN
696: where int2.locked_action_id = pai_pre.locked_action_id
697: and int2.locking_action_id = paa_run.assignment_action_id

Line 694: pay_payroll_actions pact4, --- Reversal

690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run --- RUN
696: where int2.locked_action_id = pai_pre.locked_action_id
697: and int2.locking_action_id = paa_run.assignment_action_id
698: and paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 726: pay_payroll_actions ppa_dar,

722: paa_xfr.assignment_action_id,
723: paa_xfr.assignment_id,
724: paa_xfr.tax_unit_id
725: from per_assignments_f paf,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,

Line 727: pay_payroll_actions ppa_run,

723: paa_xfr.assignment_id,
724: paa_xfr.tax_unit_id
725: from per_assignments_f paf,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,

Line 728: pay_payroll_actions ppa_pre,

724: paa_xfr.tax_unit_id
725: from per_assignments_f paf,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,

Line 734: pay_payroll_actions ppa_xfr

730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
734: pay_payroll_actions ppa_xfr
735: , pay_payrolls_f pay -- #2264358
736: where ppa_dar.payroll_action_id = pactid
737: and pyusdar_pkg.get_parameter('CONSOLIDATION_SET_ID',
738: ppa_dar.legislative_parameters) =

Line 801: pay_payroll_actions ppa_run, --- RUN

797: Select ''
798: from pay_action_interlocks int2,
799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
803: pay_assignment_actions paa_run --- RUN
804: where int2.locking_action_id = pai_pre.locked_action_id
805: and int2.locked_action_id = paa_run.assignment_action_id

Line 802: pay_payroll_actions pact4, --- Reversal

798: from pay_action_interlocks int2,
799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
803: pay_assignment_actions paa_run --- RUN
804: where int2.locking_action_id = pai_pre.locked_action_id
805: and int2.locked_action_id = paa_run.assignment_action_id
806: and paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 850: from pay_payroll_actions

846:
847: BEGIN
848: select legislative_parameters
849: into l_legislative_parameters
850: from pay_payroll_actions
851: where payroll_action_id = pactid;
852:
853: ass_set_id := pyusdar_pkg.get_parameter('ASG_SET_ID',
854: l_legislative_parameters);

Line 971: pay_payroll_actions ppa

967: from hr_all_organization_units hou,
968: per_all_people_f ppf,
969: per_all_assignments_f paf,
970: pay_assignment_actions paa,
971: pay_payroll_actions ppa
972: where ppa.payroll_action_id = :pactid
973: and paa.payroll_action_id = ppa.payroll_action_id
974: and paa.assignment_id = paf.assignment_id
975: and paf.effective_start_date =

Line 997: token_val pay_payroll_actions.legislative_parameters%type;

993: parameter_list varchar2) return varchar2
994: is
995: start_ptr number;
996: end_ptr number;
997: token_val pay_payroll_actions.legislative_parameters%type;
998: par_value pay_payroll_actions.legislative_parameters%type;
999: begin
1000: --
1001: token_val := name||'=';

Line 998: par_value pay_payroll_actions.legislative_parameters%type;

994: is
995: start_ptr number;
996: end_ptr number;
997: token_val pay_payroll_actions.legislative_parameters%type;
998: par_value pay_payroll_actions.legislative_parameters%type;
999: begin
1000: --
1001: token_val := name||'=';
1002: --