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_ASSIGNMENT_ACTIONS

Line 222: from pay_assignment_actions act,

218:
219: if l_payroll_id is not null then
220: --Bug 3331023-- Rule hint is used only for database version < 10.0
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,

Line 250: from pay_assignment_actions act,

246: --
247: else
248: --Bug 3331023-- Rule hint is used only for database version < 10.0
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,

Line 306: pay_assignment_actions paa_mag,

302: from dual
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

Line 387: from pay_assignment_actions act,

383: ) is
384: select act.assignment_action_id,
385: act.assignment_id,
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,

Line 428: pay_assignment_actions paa4,

424: AND NOT EXISTS
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

Line 431: pay_assignment_actions paa_run --- RUN

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
435: and ppa_run.action_type in ('R', 'Q')

Line 460: from pay_assignment_actions act,

456: ) is
457: select act.assignment_action_id,
458: act.assignment_id,
459: act.tax_unit_id
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,

Line 506: pay_assignment_actions paa4,

502: and not exists
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

Line 509: pay_assignment_actions paa_run, --- RUN

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
513: and int2.locked_action_id = paa_pp.assignment_action_id

Line 510: pay_assignment_actions paa_pp --- PREPAY

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
513: and int2.locked_action_id = paa_pp.assignment_action_id
514: and int2.locking_action_id = paa_run.assignment_action_id

Line 549: pay_assignment_actions paa

545:
546: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
547: select assignment_action_id
548: from pay_action_interlocks pai,
549: pay_assignment_actions paa
550: where pai.locking_action_id = cp_pre_pymt_action_id
551: and paa.assignment_Action_id = pai.locked_action_id
552: and paa.run_type_id is null
553: order by action_sequence desc;

Line 611: from pay_assignment_actions act,

607: -- if db_version is < 10 Bug 3331023
608: l_actions := 'select '||l_db_version||' distinct act.assignment_action_id,
609: act.assignment_id,
610: act.tax_unit_id
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,

Line 655: pay_assignment_actions paa4,

651: (
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

Line 658: pay_assignment_actions paa_run, --- RUN

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
662: and int2.locked_action_id = paa_pp.assignment_action_id

Line 659: pay_assignment_actions paa_pp --- PREPAY

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
662: and int2.locked_action_id = paa_pp.assignment_action_id
663: and int2.locking_action_id = paa_run.assignment_action_id

Line 749: select pay_assignment_actions_s.nextval

745: ln_source_action_id <> ln_prev_source_action_id or
746: ln_source_action_id is null) then
747:
748: hr_utility.set_location('procdar',3);
749: select pay_assignment_actions_s.nextval
750: into lockingactid
751: from dual;
752:
753: -- insert the action record.

Line 766: update pay_assignment_Actions

762: if ln_source_action_id is not null then
763:
764: hr_utility.trace('serial number updated if loop ');
765: hr_utility.trace('serial number is '||ln_source_action_id);
766: update pay_assignment_Actions
767: set serial_number = 'P'||ln_source_action_id
768: --set serial_number = ln_source_action_id
769: where assignment_action_id = lockingactid;
770: else

Line 778: update pay_assignment_Actions

774: close c_payroll_run;
775: hr_utility.trace(' ln_master_action_id is'
776: ||to_char(ln_master_action_id));
777:
778: update pay_assignment_Actions
779: set serial_number = 'M'||ln_master_action_id
780: --set serial_number = ln_master_action_id
781: where assignment_action_id = lockingactid;
782: end if;

Line 842: select pay_assignment_actions_s.nextval

838: if (ln_prev_pre_pymt_action_id is null or
839: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
840:
841: hr_utility.set_location('procdar',6);
842: select pay_assignment_actions_s.nextval
843: into ln_deposit_action_id
844: from dual;
845:
846: -- insert the action record.

Line 858: update pay_assignment_Actions

854: hr_utility.trace(' Asg id: '||to_char(ln_assignment_id));
855:
856: /* removed the commented code bug#3438254 */
857:
858: update pay_assignment_Actions
859: set serial_number = 'Z'||ln_direct_dep_act_id
860: where assignment_action_id = ln_deposit_action_id;
861:
862: -- skip till next pre payment action id

Line 893: pay_assignment_actions paa_pyarch,

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'
897: and ppa_pyarch.report_category = 'RT'

Line 935: pay_assignment_actions paa_rev, --Rev

931: and not exists
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

Line 1004: select pay_assignment_actions_s.nextval

1000: hr_utility.trace(' ln_assignment_id is' ||to_char(ln_assignment_id));
1001: hr_utility.trace(' ln_tax_unit_id is' ||to_char(ln_tax_unit_id));
1002:
1003: hr_utility.set_location('pycadar archive_action_creation',3);
1004: select pay_assignment_actions_s.nextval
1005: into ln_deposit_action_id
1006: from dual;
1007:
1008: -- insert the action record.

Line 1016: update pay_assignment_Actions

1012: hr_utility.trace('Inserted into paa, New Asg_act_id:'||to_char(ln_deposit_action_id));
1013: -- insert an interlock to this action.
1014: hr_nonrun_asact.insint(ln_deposit_action_id, ln_dd_action_id);
1015:
1016: update pay_assignment_Actions
1017: set serial_number = ln_dd_action_id
1018: where assignment_action_id = ln_deposit_action_id;
1019:
1020: END IF;

Line 1043: pay_assignment_actions paa,

1039: sqlstr := 'select paa.rowid
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