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

Line 152: from pay_payroll_actions

148: (cp_payroll_action_id in number) is
149: select legislative_parameters,
150: start_date,
151: effective_date
152: from pay_payroll_actions
153: where payroll_action_id = cp_payroll_action_id;
154:
155: lv_legislative_parameters VARCHAR2(2000);
156:

Line 192: -- leg_param pay_payroll_actions.legislative_parameters%type;

188: ----------------------------------- range_cursor ------------------------------
189: --
190: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
191: l_payroll_id number;
192: -- leg_param pay_payroll_actions.legislative_parameters%type;
193: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
194:
195: --Bug 3331023
196: l_db_version varchar2(20);

Line 232: pay_payroll_actions ppa

228: distinct paf.person_id
229: from
230: hr_assignment_set_amendments hasa,
231: per_all_assignments_f paf,
232: pay_payroll_actions ppa
233: where
234: ppa.payroll_action_id = :PACTID and
235: hasa.assignment_set_id = ' || to_char(l_asg_set_id) ||
236: ' and hasa.assignment_id = paf.assignment_id and

Line 250: pay_payroll_actions pa2,

246: sqlstr := 'select '||l_db_version||' distinct pos.person_id
247: from pay_assignment_actions act,
248: per_all_assignments_f asg,
249: per_periods_of_service pos,
250: pay_payroll_actions pa2,
251: pay_payroll_actions pa1,
252: pay_all_payrolls_f ppf
253: where pa1.payroll_action_id = :payroll_action_id
254: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',

Line 251: pay_payroll_actions pa1,

247: from pay_assignment_actions act,
248: per_all_assignments_f asg,
249: per_periods_of_service pos,
250: pay_payroll_actions pa2,
251: pay_payroll_actions pa1,
252: pay_all_payrolls_f ppf
253: where pa1.payroll_action_id = :payroll_action_id
254: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
255: pa1.legislative_parameters)

Line 278: pay_payroll_actions pa2,

274: sqlstr := 'select '||l_db_version||' distinct pos.person_id
275: from pay_assignment_actions act,
276: per_all_assignments_f asg,
277: per_periods_of_service pos,
278: pay_payroll_actions pa2,
279: pay_payroll_actions pa1,
280: pay_all_payrolls_f ppf
281: where pa1.payroll_action_id = :payroll_action_id
282: and pa2.consolidation_set_id =

Line 279: pay_payroll_actions pa1,

275: from pay_assignment_actions act,
276: per_all_assignments_f asg,
277: per_periods_of_service pos,
278: pay_payroll_actions pa2,
279: pay_payroll_actions pa1,
280: pay_all_payrolls_f ppf
281: where pa1.payroll_action_id = :payroll_action_id
282: and pa2.consolidation_set_id =
283: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

Line 332: pay_payroll_actions ppa_mag

328: where exists
329: (select 1
330: from pay_action_interlocks pai_mag,
331: pay_assignment_actions paa_mag,
332: pay_payroll_actions ppa_mag
333: where pai_mag.locked_action_id = cp_prepayment_action_id
334: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
335: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id
336: and ppa_mag.action_type = 'M'

Line 346: pay_payroll_actions ppa

342: (
343: select 1
344: from pay_action_interlocks pai,
345: pay_assignment_actions paa,
346: pay_payroll_actions ppa
347: where pai.locked_action_id = paa_mag.assignment_action_id
348: and pai.locking_Action_id = paa.assignment_action_id
349: and paa.payroll_action_id = ppa.payroll_action_id
350: and ppa.action_type = 'D'

Line 427: pay_payroll_actions ppa_dar,

423: act.tax_unit_id
424: from pay_assignment_actions act,
425: per_all_assignments_f paf1,
426: per_periods_of_service pos,
427: pay_payroll_actions ppa_dar,
428: pay_payroll_actions ppa_mag_pmts,
429: pay_all_payrolls_f ppf
430: where ( ppa_dar.payroll_action_id = pactid
431: and ppa_mag_pmts.consolidation_set_id =

Line 428: pay_payroll_actions ppa_mag_pmts,

424: from pay_assignment_actions act,
425: per_all_assignments_f paf1,
426: per_periods_of_service pos,
427: pay_payroll_actions ppa_dar,
428: pay_payroll_actions ppa_mag_pmts,
429: pay_all_payrolls_f ppf
430: where ( ppa_dar.payroll_action_id = pactid
431: and ppa_mag_pmts.consolidation_set_id =
432: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',

Line 466: pay_payroll_actions ppa_run, --- RUN

462: ( Select ' '
463: from pay_action_interlocks int2,
464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal
468: pay_assignment_actions paa_run --- RUN
469: where int2.locking_action_id = act.assignment_action_id -- prepayment action
470: and int2.locked_action_id = paa_run.assignment_action_id

Line 467: pay_payroll_actions pact4, --- Reversal

463: from pay_action_interlocks int2,
464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal
468: pay_assignment_actions paa_run --- RUN
469: where int2.locking_action_id = act.assignment_action_id -- prepayment action
470: and int2.locked_action_id = paa_run.assignment_action_id
471: and paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 501: pay_payroll_actions ppa_dar,

497: from pay_assignment_actions act,
498: per_all_assignments_f paf1,
499: per_all_assignments_f paf2,
500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,
502: pay_payroll_actions ppa_mag,
503: pay_all_payrolls_f ppf,
504: hr_assignment_sets has,
505: hr_assignment_set_amendments hasa

Line 502: pay_payroll_actions ppa_mag,

498: per_all_assignments_f paf1,
499: per_all_assignments_f paf2,
500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,
502: pay_payroll_actions ppa_mag,
503: pay_all_payrolls_f ppf,
504: hr_assignment_sets has,
505: hr_assignment_set_amendments hasa
506: where ppa_dar.payroll_action_id = pactid

Line 544: pay_payroll_actions ppa_run, --- RUN

540: ( select ''
541: from pay_action_interlocks int2,
542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN
547: pay_assignment_actions paa_pp --- PREPAY
548: where int3.locked_action_id = act.assignment_action_id

Line 545: pay_payroll_actions pact4, --- Reversal

541: from pay_action_interlocks int2,
542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN
547: pay_assignment_actions paa_pp --- PREPAY
548: where int3.locked_action_id = act.assignment_action_id
549: and int3.locking_action_id = paa_pp.assignment_action_id

Line 652: pay_payroll_actions ppa_dar,

648: from pay_assignment_actions act,
649: per_all_assignments_f paf1,
650: per_all_assignments_f paf2,
651: per_periods_of_service pos,
652: pay_payroll_actions ppa_dar,
653: pay_payroll_actions ppa_mag,
654: pay_all_payrolls_f ppf
655: where ppa_dar.payroll_action_id = :pactid
656: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =

Line 653: pay_payroll_actions ppa_mag,

649: per_all_assignments_f paf1,
650: per_all_assignments_f paf2,
651: per_periods_of_service pos,
652: pay_payroll_actions ppa_dar,
653: pay_payroll_actions ppa_mag,
654: pay_all_payrolls_f ppf
655: where ppa_dar.payroll_action_id = :pactid
656: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
657: NVL(pycadar_pkg.get_parameter(''PAYROLL_ID'',

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: pay_assignment_actions paa_pp --- PREPAY
697: where int3.locked_action_id = act.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: pay_assignment_actions paa_pp --- PREPAY
697: where int3.locked_action_id = act.assignment_action_id
698: and int3.locking_action_id = paa_pp.assignment_action_id

Line 929: from pay_payroll_actions ppa_pyarch,

925: cp_deposit_end_date in date) is
926: select paa_pyarch.assignment_action_id,
927: paa_pyarch.assignment_id,
928: paa_pyarch.tax_unit_id
929: from pay_payroll_actions ppa_pyarch,
930: pay_assignment_actions paa_pyarch,
931: per_assignments_f paf,
932: pay_action_interlocks pai_pre
933: where ppa_pyarch.report_type = 'PY_ARCHIVER'

Line 976: pay_payroll_actions ppa_rev --Rev

972: (Select 1
973: from pay_action_interlocks pai_run, --Pre > Run
974: pay_action_interlocks pai_rev, --Run > Rev
975: pay_assignment_actions paa_rev, --Rev
976: pay_payroll_actions ppa_rev --Rev
977: where pai_run.locking_action_id = pai_pre.locked_action_id
978: and pai_rev.locked_action_id = pai_run.locked_action_id
979: and paa_rev.assignment_action_id = pai_run.locking_action_id
980: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 997: pay_payroll_actions ppa_mag

993: where exists
994: (select 1
995: from PAY_EMP_NET_DIST_ACTION_INFO_V net_pay,
996: pay_assignment_actions paa_mag,
997: pay_payroll_actions ppa_mag
998: where net_pay.action_context_id = cp_action_id
999: and net_pay.pre_payment_id = paa_mag.pre_payment_id
1000: and ppa_mag.payroll_action_id = paa_mag.payroll_action_id
1001: and ppa_mag.action_type = 'M'

Line 1009: pay_payroll_actions ppa

1005: (
1006: select 1
1007: from pay_action_interlocks pai,
1008: pay_assignment_actions paa,
1009: pay_payroll_actions ppa
1010: where pai.locked_action_id = paa_mag.assignment_action_id
1011: and pai.locking_Action_id = paa.assignment_action_id
1012: and paa.payroll_action_id = ppa.payroll_action_id
1013: and ppa.action_type = 'D'

Line 1119: pay_payroll_actions ppa

1115: from hr_organization_units hou,
1116: per_people_f ppf,
1117: per_assignments_f paf,
1118: pay_assignment_actions paa,
1119: pay_payroll_actions ppa
1120: where ppa.payroll_action_id = :pactid
1121: and paa.payroll_action_id = ppa.payroll_action_id
1122: and paa.assignment_id = paf.assignment_id
1123: and ppa.effective_date between

Line 1140: token_val pay_payroll_actions.legislative_parameters%type;

1136: parameter_list varchar2) return varchar2
1137: is
1138: start_ptr number;
1139: end_ptr number;
1140: token_val pay_payroll_actions.legislative_parameters%type;
1141: par_value pay_payroll_actions.legislative_parameters%type;
1142: begin
1143: --
1144: token_val := name||'=';

Line 1141: par_value pay_payroll_actions.legislative_parameters%type;

1137: is
1138: start_ptr number;
1139: end_ptr number;
1140: token_val pay_payroll_actions.legislative_parameters%type;
1141: par_value pay_payroll_actions.legislative_parameters%type;
1142: begin
1143: --
1144: token_val := name||'=';
1145: --

Line 1271: ,pay_payroll_actions ppa

1267: SELECT /* 'Y' */
1268: distinct paa.assignment_id
1269: ,pai.action_context_id
1270: FROM pay_assignment_actions paa
1271: ,pay_payroll_actions ppa
1272: ,hr_lookups hrl
1273: ,pay_action_information pai
1274: ,per_time_periods ptp
1275: WHERE /* paa.assignment_id = c_assignment_id */

Line 1316: ,pay_payroll_actions ppa

1312: SELECT /* 'Y' */
1313: distinct paa.assignment_id
1314: ,pai.action_context_id
1315: FROM pay_assignment_actions paa
1316: ,pay_payroll_actions ppa
1317: ,hr_lookups hrl
1318: ,hr_assignment_set_amendments hasa
1319: ,pay_action_information pai
1320: ,per_time_periods ptp

Line 1550: pay_payroll_actions ppa

1546: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
1547: select paa.assignment_action_id
1548: from pay_action_interlocks paci,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa
1551: where paci.locking_action_id = cp_assignment_action_id
1552: and paa.assignment_action_id = paci.locked_action_id
1553: and ppa.payroll_action_id = paa.payroll_action_id
1554: and ppa.action_type in ('P', 'U');

Line 1568: pay_payroll_actions ppa_pre

1564: select paa_pre.assignment_action_id
1565: from pay_action_interlocks pai_run,
1566: pay_action_interlocks pai_pre,
1567: pay_assignment_actions paa_pre,
1568: pay_payroll_actions ppa_pre
1569: where pai_run.locking_action_id = cp_assignment_action_id
1570: and pai_pre.locked_action_id = pai_run.locked_action_id
1571: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
1572: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 1621: pay_payroll_actions ppa_rev --Rev

1617: (Select /*+ ORDERED */ 1
1618: from pay_action_interlocks pai_run, --Pre > Run
1619: pay_action_interlocks pai_rev, --Run > Rev
1620: pay_assignment_actions paa_rev, --Rev
1621: pay_payroll_actions ppa_rev --Rev
1622: where pai_run.locking_action_id = ln_prepay_action_id
1623: and pai_rev.locked_action_id = pai_run.locked_action_id
1624: and paa_rev.assignment_action_id = pai_run.locking_action_id
1625: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id