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

124: (cp_payroll_action_id in number) is
125: select legislative_parameters,
126: start_date,
127: effective_date
128: from pay_payroll_actions
129: where payroll_action_id = cp_payroll_action_id;
130:
131: lv_legislative_parameters VARCHAR2(2000);
132:

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

164: ----------------------------------- range_cursor ------------------------------
165: --
166: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
167: l_payroll_id number;
168: -- leg_param pay_payroll_actions.legislative_parameters%type;
169: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
170:
171: --Bug 3331023
172: l_db_version varchar2(20);

Line 208: pay_payroll_actions ppa

204: distinct paf.person_id
205: from
206: hr_assignment_set_amendments hasa,
207: per_all_assignments_f paf,
208: pay_payroll_actions ppa
209: where
210: ppa.payroll_action_id = :PACTID and
211: hasa.assignment_set_id = ' || to_char(l_asg_set_id) ||
212: ' and hasa.assignment_id = paf.assignment_id and

Line 225: pay_payroll_actions pa2,

221: sqlstr := 'select '||l_db_version||' distinct pos.person_id
222: from pay_assignment_actions act,
223: per_all_assignments_f asg,
224: per_periods_of_service pos,
225: pay_payroll_actions pa2,
226: pay_payroll_actions pa1,
227: pay_all_payrolls_f ppf
228: where pa1.payroll_action_id = :payroll_action_id
229: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',

Line 226: pay_payroll_actions pa1,

222: from pay_assignment_actions act,
223: per_all_assignments_f asg,
224: per_periods_of_service pos,
225: pay_payroll_actions pa2,
226: pay_payroll_actions pa1,
227: pay_all_payrolls_f ppf
228: where pa1.payroll_action_id = :payroll_action_id
229: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
230: pa1.legislative_parameters)

Line 253: pay_payroll_actions pa2,

249: sqlstr := 'select '||l_db_version||' distinct pos.person_id
250: from pay_assignment_actions act,
251: per_all_assignments_f asg,
252: per_periods_of_service pos,
253: pay_payroll_actions pa2,
254: pay_payroll_actions pa1,
255: pay_all_payrolls_f ppf
256: where pa1.payroll_action_id = :payroll_action_id
257: and pa2.consolidation_set_id =

Line 254: pay_payroll_actions pa1,

250: from pay_assignment_actions act,
251: per_all_assignments_f asg,
252: per_periods_of_service pos,
253: pay_payroll_actions pa2,
254: pay_payroll_actions pa1,
255: pay_all_payrolls_f ppf
256: where pa1.payroll_action_id = :payroll_action_id
257: and pa2.consolidation_set_id =
258: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',

Line 307: pay_payroll_actions ppa_mag

303: where exists
304: (select 1
305: from pay_action_interlocks pai_mag,
306: pay_assignment_actions paa_mag,
307: pay_payroll_actions ppa_mag
308: where pai_mag.locked_action_id = cp_prepayment_action_id
309: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
310: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id
311: and ppa_mag.action_type = 'M'

Line 390: pay_payroll_actions ppa_dar,

386: act.tax_unit_id
387: from pay_assignment_actions act,
388: per_all_assignments_f paf1,
389: per_periods_of_service pos,
390: pay_payroll_actions ppa_dar,
391: pay_payroll_actions ppa_mag_pmts,
392: pay_all_payrolls_f ppf
393: where ( ppa_dar.payroll_action_id = pactid
394: and ppa_mag_pmts.consolidation_set_id =

Line 391: pay_payroll_actions ppa_mag_pmts,

387: from pay_assignment_actions act,
388: per_all_assignments_f paf1,
389: per_periods_of_service pos,
390: pay_payroll_actions ppa_dar,
391: pay_payroll_actions ppa_mag_pmts,
392: pay_all_payrolls_f ppf
393: where ( ppa_dar.payroll_action_id = pactid
394: and ppa_mag_pmts.consolidation_set_id =
395: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',

Line 429: pay_payroll_actions ppa_run, --- RUN

425: ( Select ' '
426: from pay_action_interlocks int2,
427: pay_action_interlocks int4,
428: pay_assignment_actions paa4,
429: pay_payroll_actions ppa_run, --- RUN
430: pay_payroll_actions pact4, --- Reversal
431: pay_assignment_actions paa_run --- RUN
432: where int2.locking_action_id = act.assignment_action_id -- prepayment action
433: and int2.locked_action_id = paa_run.assignment_action_id

Line 430: pay_payroll_actions pact4, --- Reversal

426: from pay_action_interlocks int2,
427: pay_action_interlocks int4,
428: pay_assignment_actions paa4,
429: pay_payroll_actions ppa_run, --- RUN
430: pay_payroll_actions pact4, --- Reversal
431: pay_assignment_actions paa_run --- RUN
432: where int2.locking_action_id = act.assignment_action_id -- prepayment action
433: and int2.locked_action_id = paa_run.assignment_action_id
434: and paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 464: pay_payroll_actions ppa_dar,

460: from pay_assignment_actions act,
461: per_all_assignments_f paf1,
462: per_all_assignments_f paf2,
463: per_periods_of_service pos,
464: pay_payroll_actions ppa_dar,
465: pay_payroll_actions ppa_mag,
466: pay_all_payrolls_f ppf,
467: hr_assignment_sets has,
468: hr_assignment_set_amendments hasa

Line 465: pay_payroll_actions ppa_mag,

461: per_all_assignments_f paf1,
462: per_all_assignments_f paf2,
463: per_periods_of_service pos,
464: pay_payroll_actions ppa_dar,
465: pay_payroll_actions ppa_mag,
466: pay_all_payrolls_f ppf,
467: hr_assignment_sets has,
468: hr_assignment_set_amendments hasa
469: where ppa_dar.payroll_action_id = pactid

Line 507: pay_payroll_actions ppa_run, --- RUN

503: ( select ''
504: from pay_action_interlocks int2,
505: pay_action_interlocks int3,
506: pay_assignment_actions paa4,
507: pay_payroll_actions ppa_run, --- RUN
508: pay_payroll_actions pact4, --- Reversal
509: pay_assignment_actions paa_run, --- RUN
510: pay_assignment_actions paa_pp --- PREPAY
511: where int3.locked_action_id = act.assignment_action_id

Line 508: pay_payroll_actions pact4, --- Reversal

504: from pay_action_interlocks int2,
505: pay_action_interlocks int3,
506: pay_assignment_actions paa4,
507: pay_payroll_actions ppa_run, --- RUN
508: pay_payroll_actions pact4, --- Reversal
509: pay_assignment_actions paa_run, --- RUN
510: pay_assignment_actions paa_pp --- PREPAY
511: where int3.locked_action_id = act.assignment_action_id
512: and int3.locking_action_id = paa_pp.assignment_action_id

Line 615: pay_payroll_actions ppa_dar,

611: from pay_assignment_actions act,
612: per_all_assignments_f paf1,
613: per_all_assignments_f paf2,
614: per_periods_of_service pos,
615: pay_payroll_actions ppa_dar,
616: pay_payroll_actions ppa_mag,
617: pay_all_payrolls_f ppf
618: where ppa_dar.payroll_action_id = :pactid
619: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =

Line 616: pay_payroll_actions ppa_mag,

612: per_all_assignments_f paf1,
613: per_all_assignments_f paf2,
614: per_periods_of_service pos,
615: pay_payroll_actions ppa_dar,
616: pay_payroll_actions ppa_mag,
617: pay_all_payrolls_f ppf
618: where ppa_dar.payroll_action_id = :pactid
619: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
620: NVL(pycadar_pkg.get_parameter(''PAYROLL_ID'',

Line 656: pay_payroll_actions ppa_run, --- RUN

652: Select ''''
653: from pay_action_interlocks int2,
654: pay_action_interlocks int3,
655: pay_assignment_actions paa4,
656: pay_payroll_actions ppa_run, --- RUN
657: pay_payroll_actions pact4, --- Reversal
658: pay_assignment_actions paa_run, --- RUN
659: pay_assignment_actions paa_pp --- PREPAY
660: where int3.locked_action_id = act.assignment_action_id

Line 657: pay_payroll_actions pact4, --- Reversal

653: from pay_action_interlocks int2,
654: pay_action_interlocks int3,
655: pay_assignment_actions paa4,
656: pay_payroll_actions ppa_run, --- RUN
657: pay_payroll_actions pact4, --- Reversal
658: pay_assignment_actions paa_run, --- RUN
659: pay_assignment_actions paa_pp --- PREPAY
660: where int3.locked_action_id = act.assignment_action_id
661: and int3.locking_action_id = paa_pp.assignment_action_id

Line 892: from pay_payroll_actions ppa_pyarch,

888: cp_deposit_end_date in date) is
889: select paa_pyarch.assignment_action_id,
890: paa_pyarch.assignment_id,
891: paa_pyarch.tax_unit_id
892: from pay_payroll_actions ppa_pyarch,
893: pay_assignment_actions paa_pyarch,
894: per_assignments_f paf,
895: pay_action_interlocks pai_pre
896: where ppa_pyarch.report_type = 'PY_ARCHIVER'

Line 936: pay_payroll_actions ppa_rev --Rev

932: (Select 1
933: from pay_action_interlocks pai_run, --Pre > Run
934: pay_action_interlocks pai_rev, --Run > Rev
935: pay_assignment_actions paa_rev, --Rev
936: pay_payroll_actions ppa_rev --Rev
937: where pai_run.locking_action_id = pai_pre.locked_action_id
938: and pai_rev.locked_action_id = pai_run.locked_action_id
939: and paa_rev.assignment_action_id = pai_run.locking_action_id
940: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 1044: pay_payroll_actions ppa

1040: from hr_organization_units hou,
1041: per_people_f ppf,
1042: per_assignments_f paf,
1043: pay_assignment_actions paa,
1044: pay_payroll_actions ppa
1045: where ppa.payroll_action_id = :pactid
1046: and paa.payroll_action_id = ppa.payroll_action_id
1047: and paa.assignment_id = paf.assignment_id
1048: and ppa.effective_date between

Line 1065: token_val pay_payroll_actions.legislative_parameters%type;

1061: parameter_list varchar2) return varchar2
1062: is
1063: start_ptr number;
1064: end_ptr number;
1065: token_val pay_payroll_actions.legislative_parameters%type;
1066: par_value pay_payroll_actions.legislative_parameters%type;
1067: begin
1068: --
1069: token_val := name||'=';

Line 1066: par_value pay_payroll_actions.legislative_parameters%type;

1062: is
1063: start_ptr number;
1064: end_ptr number;
1065: token_val pay_payroll_actions.legislative_parameters%type;
1066: par_value pay_payroll_actions.legislative_parameters%type;
1067: begin
1068: --
1069: token_val := name||'=';
1070: --