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

Line 124: from pay_payroll_actions

120: (cp_payroll_action_id in number) is
121: select legislative_parameters,
122: start_date,
123: effective_date
124: from pay_payroll_actions
125: where payroll_action_id = cp_payroll_action_id;
126:
127: lv_legislative_parameters VARCHAR2(2000);
128:

Line 179: from pay_payroll_actions

175: (cp_payroll_action_id in number) is
176: select legislative_parameters,
177: start_date,
178: effective_date
179: from pay_payroll_actions
180: where payroll_action_id = cp_payroll_action_id;
181:
182: lv_legislative_parameters VARCHAR2(2000);
183:

Line 263: pay_payroll_actions ppa

259:
260: if ln_payroll_id is not null then
261: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
262: from pay_assignment_actions paa,
263: pay_payroll_actions ppa
264: where :payroll_action_id is not null
265: and ppa.action_type in (''R'',''Q'')
266: and ppa.consolidation_set_id = ' || ln_consolidation_set_id
267: || ' and ppa.payroll_id = ' || ln_payroll_id

Line 276: pay_payroll_actions ppa

272:
273: else
274: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
275: from pay_assignment_actions paa,
276: pay_payroll_actions ppa
277: where :payroll_action_id is not null
278: and ppa.action_type in (''R'',''Q'')
279: and ppa.consolidation_set_id = ' || ln_consolidation_set_id
280: || ' and ppa.effective_date between ''' || ld_deposit_start_date

Line 315: pay_payroll_actions ppa_mag,

311: where exists
312: (select 1
313: from pay_action_interlocks pai_mag,
314: pay_assignment_actions paa_mag,
315: pay_payroll_actions ppa_mag,
316: pay_org_payment_methods_f popm,
317: pay_pre_payments ppp,
318: pay_payment_types ppt
319: where pai_mag.locked_action_id = cp_prepayment_action_id

Line 399: pay_payroll_actions ppa

395: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
396: select paa.assignment_action_id
397: from pay_action_interlocks paci,
398: pay_assignment_actions paa,
399: pay_payroll_actions ppa
400: where paci.locking_action_id = cp_assignment_action_id
401: and paa.assignment_action_id = paci.locked_action_id
402: and ppa.payroll_action_id = paa.payroll_action_id
403: and ppa.action_type in ('P', 'U');

Line 417: pay_payroll_actions ppa_pre

413: select paa_pre.assignment_action_id
414: from pay_action_interlocks pai_run,
415: pay_action_interlocks pai_pre,
416: pay_assignment_actions paa_pre,
417: pay_payroll_actions ppa_pre
418: where pai_run.locking_action_id = cp_assignment_action_id
419: and pai_pre.locked_action_id = pai_run.locked_action_id
420: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
421: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 470: pay_payroll_actions ppa_rev --Rev

466: (Select /*+ ORDERED */ 1
467: from pay_action_interlocks pai_run, --Pre > Run
468: pay_action_interlocks pai_rev, --Run > Rev
469: pay_assignment_actions paa_rev, --Rev
470: pay_payroll_actions ppa_rev --Rev
471: where pai_run.locking_action_id = ln_prepay_action_id
472: and pai_rev.locked_action_id = pai_run.locked_action_id
473: and paa_rev.assignment_action_id = pai_run.locking_action_id
474: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 516: pay_payroll_actions ppa_xfr,

512: paa_xfr.assignment_action_id,
513: paa_xfr.assignment_id,
514: paa_xfr.tax_unit_id
515: from
516: pay_payroll_actions ppa_xfr,
517: pay_assignment_actions paa_xfr,
518: pay_action_interlocks pai_pre
519: where ppa_xfr.report_type = 'XFR_INTERFACE'
520: and ppa_xfr.report_category = 'RT'

Line 554: pay_payroll_actions ppa_rev --Rev

550: (Select /*+ ORDERED */ 1
551: from pay_action_interlocks pai_run, --Pre > Run
552: pay_action_interlocks pai_rev, --Run > Rev
553: pay_assignment_actions paa_rev, --Rev
554: pay_payroll_actions ppa_rev --Rev
555: where pai_run.locking_action_id = pai_pre.locked_action_id
556: and pai_rev.locked_action_id = pai_run.locked_action_id
557: and paa_rev.assignment_action_id = pai_run.locking_action_id
558: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 683: pay_payroll_actions ppa

679: from hr_all_organization_units hou,
680: per_all_people_f ppf,
681: per_all_assignments_f paf,
682: pay_assignment_actions paa,
683: pay_payroll_actions ppa
684: where ppa.payroll_action_id = :pactid
685: and paa.payroll_action_id = ppa.payroll_action_id
686: and paa.assignment_id = paf.assignment_id
687: and paf.effective_start_date =

Line 735: pay_payroll_actions ppa_dar,

731: act.tax_unit_id,
732: ppa_mag.effective_date,
733: ppa_mag.action_type
734: from pay_assignment_actions act,
735: pay_payroll_actions ppa_dar,
736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,

Line 736: pay_payroll_actions ppa_mag,

732: ppa_mag.effective_date,
733: ppa_mag.action_type
734: from pay_assignment_actions act,
735: pay_payroll_actions ppa_dar,
736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,

Line 788: pay_payroll_actions ppa_run, --- RUN

784: ( select ''
785: from pay_action_interlocks int2,
786: pay_action_interlocks int3,
787: pay_assignment_actions paa4,
788: pay_payroll_actions ppa_run, --- RUN
789: pay_payroll_actions pact4, --- Reversal
790: pay_assignment_actions paa_run, --- RUN
791: pay_assignment_actions paa_pp --- PREPAY
792: where int3.locked_action_id = act.assignment_action_id

Line 789: pay_payroll_actions pact4, --- Reversal

785: from pay_action_interlocks int2,
786: pay_action_interlocks int3,
787: pay_assignment_actions paa4,
788: pay_payroll_actions ppa_run, --- RUN
789: pay_payroll_actions pact4, --- Reversal
790: pay_assignment_actions paa_run, --- RUN
791: pay_assignment_actions paa_pp --- PREPAY
792: where int3.locked_action_id = act.assignment_action_id
793: and int3.locking_action_id = paa_pp.assignment_action_id

Line 899: pay_payroll_actions ppa_dar,

895: act.tax_unit_id,
896: ppa_mag.effective_date,
897: ppa_mag.action_type
898: from pay_assignment_actions act,
899: pay_payroll_actions ppa_dar,
900: pay_payroll_actions ppa_mag,
901: per_all_assignments_f paf2,
902: pay_org_payment_methods_f popm, --Bug 3009643
903: pay_payrolls_f pay --Bug 3343621

Line 900: pay_payroll_actions ppa_mag,

896: ppa_mag.effective_date,
897: ppa_mag.action_type
898: from pay_assignment_actions act,
899: pay_payroll_actions ppa_dar,
900: pay_payroll_actions ppa_mag,
901: per_all_assignments_f paf2,
902: pay_org_payment_methods_f popm, --Bug 3009643
903: pay_payrolls_f pay --Bug 3343621
904: where ppa_dar.payroll_action_id = :pactid

Line 947: pay_payroll_actions ppa_run, --- RUN

943: Select ''''
944: from pay_action_interlocks int2,
945: pay_action_interlocks int3,
946: pay_assignment_actions paa4,
947: pay_payroll_actions ppa_run, --- RUN
948: pay_payroll_actions pact4, --- Reversal
949: pay_assignment_actions paa_run, --- RUN
950: pay_assignment_actions paa_pp --- PREPAY
951: where

Line 948: pay_payroll_actions pact4, --- Reversal

944: from pay_action_interlocks int2,
945: pay_action_interlocks int3,
946: pay_assignment_actions paa4,
947: pay_payroll_actions ppa_run, --- RUN
948: pay_payroll_actions pact4, --- Reversal
949: pay_assignment_actions paa_run, --- RUN
950: pay_assignment_actions paa_pp --- PREPAY
951: where
952: int3.locked_action_id = act.assignment_action_id

Line 1173: ,pay_payroll_actions ppa

1169: SELECT /* 'Y' */
1170: distinct paa.assignment_id
1171: ,pai.action_context_id
1172: FROM pay_assignment_actions paa
1173: ,pay_payroll_actions ppa
1174: ,hr_lookups hrl
1175: ,pay_action_information pai
1176: ,per_time_periods ptp
1177: WHERE /* paa.assignment_id = c_assignment_id */

Line 1218: ,pay_payroll_actions ppa

1214: SELECT /* 'Y' */
1215: distinct paa.assignment_id
1216: ,pai.action_context_id
1217: FROM pay_assignment_actions paa
1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp

Line 1490: pay_payroll_actions ppa,

1486: if ln_assignment_set_id is not null then
1487:
1488: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1489: from pay_assignment_actions paa,
1490: pay_payroll_actions ppa,
1491: per_assignments_f paf,
1492: hr_assignment_set_amendments hasa
1493: where :payroll_action_id is not null
1494: and ppa.action_type in (''R'',''Q'')

Line 1508: pay_payroll_actions ppa,

1504: || ' order by paf.person_id';
1505: else
1506: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1507: from pay_assignment_actions paa,
1508: pay_payroll_actions ppa,
1509: per_assignments_f paf
1510: where :payroll_action_id is not null
1511: and ppa.action_type in (''R'',''Q'')
1512: and paa.assignment_id = paf.assignment_id

Line 1525: pay_payroll_actions ppa,

1521: else
1522: if ln_assignment_set_id is not null then
1523: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1524: from pay_assignment_actions paa,
1525: pay_payroll_actions ppa,
1526: per_assignments_f paf,
1527: hr_assignment_set_amendments hasa
1528: where :payroll_action_id is not null
1529: and ppa.action_type in (''R'',''Q'')

Line 1543: pay_payroll_actions ppa,

1539:
1540: else
1541: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1542: from pay_assignment_actions paa,
1543: pay_payroll_actions ppa,
1544: per_assignments_f paf
1545: where :payroll_action_id is not null
1546: and ppa.action_type in (''R'',''Q'')
1547: and paa.assignment_id = paf.assignment_id