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_MX_SUA_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 369: FROM pay_assignment_actions paa_arch,

365: -- Bug 4518777
366: p_sqlstr := '
367: SELECT DISTINCT substr(paa_arch.serial_number, 1,
368: instr(paa_arch.serial_number, ''|'')-1)
369: FROM pay_assignment_actions paa_arch,
370: pay_payroll_actions ppa_arch
371: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
372: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',

Line 410: FROM pay_assignment_actions paa_arch,

406: SELECT paa_arch.assignment_action_id,
407: paf.assignment_id,
408: paf.person_id,
409: ppa_arch.payroll_action_id
410: FROM pay_assignment_actions paa_arch,
411: pay_payroll_actions ppa_arch,
412: per_all_assignments_f paf,
413: pay_action_information pai
414: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 451: pay_assignment_actions paa_sua,

447: )
448: AND paa_arch.tax_unit_id = g_mag_gre_id
449: /*AND NOT EXISTS (SELECT 'X'
450: FROM pay_payroll_actions ppa_sua,
451: pay_assignment_actions paa_sua,
452: pay_action_interlocks lck
453: WHERE lck.locked_action_id = pai.action_context_id
454: AND lck.locking_action_id =
455: paa_sua.assignment_action_id

Line 480: FROM pay_assignment_actions paa_arch,

476: SELECT paa_arch.assignment_action_id,
477: paf.assignment_id,
478: paf.person_id,
479: ppa_arch.payroll_action_id
480: FROM pay_assignment_actions paa_arch,
481: pay_payroll_actions ppa_arch,
482: per_all_assignments_f paf,
483: pay_population_ranges ppr,
484: pay_action_information pai

Line 523: pay_assignment_actions paa_sua,

519: )
520: AND paa_arch.tax_unit_id = g_mag_gre_id
521: /*AND NOT EXISTS (SELECT 'X'
522: FROM pay_payroll_actions ppa_sua,
523: pay_assignment_actions paa_sua,
524: pay_action_interlocks lck
525: WHERE lck.locked_action_id = pai.action_context_id
526: AND lck.locking_action_id =
527: paa_sua.assignment_action_id

Line 575: pay_assignment_actions paa,

571: SUA Mag report*/
572: CURSOR c_report_type (p_arch_asg_act NUMBER) IS
573: SELECT count(*)
574: FROM pay_payroll_actions pact,
575: pay_assignment_actions paa,
576: pay_action_interlocks pail
577: WHERE p_arch_asg_act = pail.locked_action_id
578: AND pail.locking_action_id = paa.assignment_action_id
579: AND paa.payroll_action_id = pact.payroll_action_id

Line 698: SELECT pay_assignment_actions_s.nextval

694: it is not locked by another SUA Mag report or if it has not been reported yet.
695: The following IF condition is used for that purpose.*/
696: IF (ln_exist = 0 OR l_report = 0) THEN
697: IF (ln_person_id <> ln_prev_person_id) THEN
698: SELECT pay_assignment_actions_s.nextval
699: INTO ln_mag_asg_act_id
700: FROM dual;
701:
702: hr_utility_trace('Creating magtape assignment action '||

Line 782: pay_assignment_actions paa_arch,

778: pai.action_context_id,
779: pai.action_information_id,
780: nvl(pai.action_information21, 'N') -- Do not report flag
781: FROM pay_action_information pai,
782: pay_assignment_actions paa_arch,
783: per_all_assignments_f paf,
784: pay_action_interlocks lck
785: WHERE pai.action_context_id = paa_arch.assignment_action_id
786: AND paf.assignment_id = paa_arch.assignment_id

Line 813: pay_assignment_actions paa_arch,

809: fnd_number.canonical_to_number(pai.action_information8), --IDW
810: pai.action_information2, -- transaction date
811: pai.action_information24 -- Report Rehire Termination
812: FROM pay_action_information pai,
813: pay_assignment_actions paa_arch,
814: per_all_assignments_f paf,
815: pay_action_interlocks lck
816: WHERE pai.action_context_id = paa_arch.assignment_action_id
817: AND paf.assignment_id = paa_arch.assignment_id

Line 855: FROM pay_assignment_actions paa_mag,

851: cp_person_id varchar2,
852: cp_tran_type varchar2,
853: cp_tran_dt date) IS
854: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
855: FROM pay_assignment_actions paa_mag,
856: pay_payroll_actions ppa_mag,
857: pay_assignment_actions paa_mag_prev,
858: pay_payroll_actions ppa_mag_prev,
859: pay_action_information pai,

Line 857: pay_assignment_actions paa_mag_prev,

853: cp_tran_dt date) IS
854: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
855: FROM pay_assignment_actions paa_mag,
856: pay_payroll_actions ppa_mag,
857: pay_assignment_actions paa_mag_prev,
858: pay_payroll_actions ppa_mag_prev,
859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 887: FROM pay_assignment_actions paa,

883: AND ppa_mag_prev.action_status = 'C';
884:
885: CURSOR csr_person (cp_asg_act_id number) IS
886: SELECT DISTINCT paf.person_id
887: FROM pay_assignment_actions paa,
888: per_assignments_f paf
889: WHERE paf.assignment_id = paa.assignment_id
890: AND paa.assignment_action_id = cp_asg_act_id;
891:

Line 903: pay_assignment_actions paa,

899: fnd_date.canonical_to_date(
900: pay_mx_utility.get_legi_param_val('END_DATE',
901: ppa.legislative_parameters))
902: FROM pay_payroll_actions ppa,
903: pay_assignment_actions paa,
904: per_assignments_f paf
905: WHERE ppa.payroll_action_id = paa.payroll_action_id
906: AND paa.assignment_id = paf.assignment_id
907: AND paf.person_id = cp_person_id

Line 936: pay_assignment_actions paa_sua,

932:
933: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
934: SELECT fnd_number.canonical_to_number(pai.action_information8)
935: FROM pay_payroll_actions ppa_sua,
936: pay_assignment_actions paa_sua,
937: pay_assignment_actions paa_arch,
938: pay_action_interlocks lck,
939: pay_action_information pai
940: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id

Line 937: pay_assignment_actions paa_arch,

933: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
934: SELECT fnd_number.canonical_to_number(pai.action_information8)
935: FROM pay_payroll_actions ppa_sua,
936: pay_assignment_actions paa_sua,
937: pay_assignment_actions paa_arch,
938: pay_action_interlocks lck,
939: pay_action_information pai
940: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
941: AND paa_sua.assignment_action_id = lck.locking_action_id

Line 1331: FROM pay_assignment_actions paa_arch,

1327:
1328: -- Bug 4864237
1329: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1330: SELECT DISTINCT paa_arch.payroll_action_id
1331: FROM pay_assignment_actions paa_arch,
1332: pay_assignment_actions paa_mag,
1333: pay_action_interlocks lck
1334: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1335: AND lck.locking_action_id = paa_mag.assignment_action_id

Line 1332: pay_assignment_actions paa_mag,

1328: -- Bug 4864237
1329: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1330: SELECT DISTINCT paa_arch.payroll_action_id
1331: FROM pay_assignment_actions paa_arch,
1332: pay_assignment_actions paa_mag,
1333: pay_action_interlocks lck
1334: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1335: AND lck.locking_action_id = paa_mag.assignment_action_id
1336: AND paa_mag.chunk_number >= cp_chunk