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 119: from pay_payroll_actions

115: (cp_payroll_action_id in number) is
116: select legislative_parameters,
117: start_date,
118: effective_date
119: from pay_payroll_actions
120: where payroll_action_id = cp_payroll_action_id;
121:
122: lv_legislative_parameters VARCHAR2(2000);
123:

Line 174: from pay_payroll_actions

170: (cp_payroll_action_id in number) is
171: select legislative_parameters,
172: start_date,
173: effective_date
174: from pay_payroll_actions
175: where payroll_action_id = cp_payroll_action_id;
176:
177: lv_legislative_parameters VARCHAR2(2000);
178:

Line 258: pay_payroll_actions ppa

254:
255: if ln_payroll_id is not null then
256: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
257: from pay_assignment_actions paa,
258: pay_payroll_actions ppa
259: where :payroll_action_id is not null
260: and ppa.action_type in (''R'',''Q'')
261: and ppa.consolidation_set_id = ' || ln_consolidation_set_id
262: || ' and ppa.payroll_id = ' || ln_payroll_id

Line 271: pay_payroll_actions ppa

267:
268: else
269: sqlstr := 'select '||l_db_version||' distinct paa.assignment_id
270: from pay_assignment_actions paa,
271: pay_payroll_actions ppa
272: where :payroll_action_id is not null
273: and ppa.action_type in (''R'',''Q'')
274: and ppa.consolidation_set_id = ' || ln_consolidation_set_id
275: || ' and ppa.effective_date between ''' || ld_deposit_start_date

Line 310: pay_payroll_actions ppa_mag,

306: where exists
307: (select 1
308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
310: pay_payroll_actions ppa_mag,
311: pay_org_payment_methods_f popm,
312: pay_pre_payments ppp,
313: pay_payment_types ppt
314: where pai_mag.locked_action_id = cp_prepayment_action_id

Line 394: pay_payroll_actions ppa

390: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
391: select paa.assignment_action_id
392: from pay_action_interlocks paci,
393: pay_assignment_actions paa,
394: pay_payroll_actions ppa
395: where paci.locking_action_id = cp_assignment_action_id
396: and paa.assignment_action_id = paci.locked_action_id
397: and ppa.payroll_action_id = paa.payroll_action_id
398: and ppa.action_type in ('P', 'U');

Line 412: pay_payroll_actions ppa_pre

408: select paa_pre.assignment_action_id
409: from pay_action_interlocks pai_run,
410: pay_action_interlocks pai_pre,
411: pay_assignment_actions paa_pre,
412: pay_payroll_actions ppa_pre
413: where pai_run.locking_action_id = cp_assignment_action_id
414: and pai_pre.locked_action_id = pai_run.locked_action_id
415: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
416: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 465: pay_payroll_actions ppa_rev --Rev

461: (Select /*+ ORDERED */ 1
462: from pay_action_interlocks pai_run, --Pre > Run
463: pay_action_interlocks pai_rev, --Run > Rev
464: pay_assignment_actions paa_rev, --Rev
465: pay_payroll_actions ppa_rev --Rev
466: where pai_run.locking_action_id = ln_prepay_action_id
467: and pai_rev.locked_action_id = pai_run.locked_action_id
468: and paa_rev.assignment_action_id = pai_run.locking_action_id
469: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 511: pay_payroll_actions ppa_xfr,

507: paa_xfr.assignment_action_id,
508: paa_xfr.assignment_id,
509: paa_xfr.tax_unit_id
510: from
511: pay_payroll_actions ppa_xfr,
512: pay_assignment_actions paa_xfr,
513: pay_action_interlocks pai_pre
514: where ppa_xfr.report_type = 'XFR_INTERFACE'
515: and ppa_xfr.report_category = 'RT'

Line 547: pay_payroll_actions ppa_rev --Rev

543: (Select /*+ ORDERED */ 1
544: from pay_action_interlocks pai_run, --Pre > Run
545: pay_action_interlocks pai_rev, --Run > Rev
546: pay_assignment_actions paa_rev, --Rev
547: pay_payroll_actions ppa_rev --Rev
548: where pai_run.locking_action_id = pai_pre.locked_action_id
549: and pai_rev.locked_action_id = pai_run.locked_action_id
550: and paa_rev.assignment_action_id = pai_run.locking_action_id
551: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 673: pay_payroll_actions ppa

669: from hr_all_organization_units hou,
670: per_all_people_f ppf,
671: per_all_assignments_f paf,
672: pay_assignment_actions paa,
673: pay_payroll_actions ppa
674: where ppa.payroll_action_id = :pactid
675: and paa.payroll_action_id = ppa.payroll_action_id
676: and paa.assignment_id = paf.assignment_id
677: and paf.effective_start_date =

Line 725: pay_payroll_actions ppa_dar,

721: act.tax_unit_id,
722: ppa_mag.effective_date,
723: ppa_mag.action_type
724: from pay_assignment_actions act,
725: pay_payroll_actions ppa_dar,
726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,

Line 726: pay_payroll_actions ppa_mag,

722: ppa_mag.effective_date,
723: ppa_mag.action_type
724: from pay_assignment_actions act,
725: pay_payroll_actions ppa_dar,
726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,

Line 778: pay_payroll_actions ppa_run, --- RUN

774: ( select ''
775: from pay_action_interlocks int2,
776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN
781: pay_assignment_actions paa_pp --- PREPAY
782: where int3.locked_action_id = act.assignment_action_id

Line 779: pay_payroll_actions pact4, --- Reversal

775: from pay_action_interlocks int2,
776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN
781: pay_assignment_actions paa_pp --- PREPAY
782: where int3.locked_action_id = act.assignment_action_id
783: and int3.locking_action_id = paa_pp.assignment_action_id

Line 889: pay_payroll_actions ppa_dar,

885: act.tax_unit_id,
886: ppa_mag.effective_date,
887: ppa_mag.action_type
888: from pay_assignment_actions act,
889: pay_payroll_actions ppa_dar,
890: pay_payroll_actions ppa_mag,
891: per_all_assignments_f paf2,
892: pay_org_payment_methods_f popm, --Bug 3009643
893: pay_payrolls_f pay --Bug 3343621

Line 890: pay_payroll_actions ppa_mag,

886: ppa_mag.effective_date,
887: ppa_mag.action_type
888: from pay_assignment_actions act,
889: pay_payroll_actions ppa_dar,
890: pay_payroll_actions ppa_mag,
891: per_all_assignments_f paf2,
892: pay_org_payment_methods_f popm, --Bug 3009643
893: pay_payrolls_f pay --Bug 3343621
894: where ppa_dar.payroll_action_id = :pactid

Line 937: pay_payroll_actions ppa_run, --- RUN

933: Select ''''
934: from pay_action_interlocks int2,
935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN
940: pay_assignment_actions paa_pp --- PREPAY
941: where

Line 938: pay_payroll_actions pact4, --- Reversal

934: from pay_action_interlocks int2,
935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN
940: pay_assignment_actions paa_pp --- PREPAY
941: where
942: int3.locked_action_id = act.assignment_action_id

Line 1163: ,pay_payroll_actions ppa

1159: SELECT /* 'Y' */
1160: distinct paa.assignment_id
1161: ,pai.action_context_id
1162: FROM pay_assignment_actions paa
1163: ,pay_payroll_actions ppa
1164: ,hr_lookups hrl
1165: ,pay_action_information pai
1166: ,per_time_periods ptp
1167: WHERE /* paa.assignment_id = c_assignment_id */

Line 1208: ,pay_payroll_actions ppa

1204: SELECT /* 'Y' */
1205: distinct paa.assignment_id
1206: ,pai.action_context_id
1207: FROM pay_assignment_actions paa
1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai
1212: ,per_time_periods ptp

Line 1480: pay_payroll_actions ppa,

1476: if ln_assignment_set_id is not null then
1477:
1478: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1479: from pay_assignment_actions paa,
1480: pay_payroll_actions ppa,
1481: per_assignments_f paf,
1482: hr_assignment_set_amendments hasa
1483: where :payroll_action_id is not null
1484: and ppa.action_type in (''R'',''Q'')

Line 1498: pay_payroll_actions ppa,

1494: || ' order by paf.person_id';
1495: else
1496: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1497: from pay_assignment_actions paa,
1498: pay_payroll_actions ppa,
1499: per_assignments_f paf
1500: where :payroll_action_id is not null
1501: and ppa.action_type in (''R'',''Q'')
1502: and paa.assignment_id = paf.assignment_id

Line 1515: pay_payroll_actions ppa,

1511: else
1512: if ln_assignment_set_id is not null then
1513: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1514: from pay_assignment_actions paa,
1515: pay_payroll_actions ppa,
1516: per_assignments_f paf,
1517: hr_assignment_set_amendments hasa
1518: where :payroll_action_id is not null
1519: and ppa.action_type in (''R'',''Q'')

Line 1533: pay_payroll_actions ppa,

1529:
1530: else
1531: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1532: from pay_assignment_actions paa,
1533: pay_payroll_actions ppa,
1534: per_assignments_f paf
1535: where :payroll_action_id is not null
1536: and ppa.action_type in (''R'',''Q'')
1537: and paa.assignment_id = paf.assignment_id