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 341: FROM pay_assignment_actions paa_arch,

337: -- Bug 4518777
338: p_sqlstr := '
339: SELECT DISTINCT substr(paa_arch.serial_number, 1,
340: instr(paa_arch.serial_number, ''|'')-1)
341: FROM pay_assignment_actions paa_arch,
342: pay_payroll_actions ppa_arch
343: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
344: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
345: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',

Line 381: FROM pay_assignment_actions paa_arch,

377: SELECT paa_arch.assignment_action_id,
378: paf.assignment_id,
379: paf.person_id,
380: ppa_arch.payroll_action_id
381: FROM pay_assignment_actions paa_arch,
382: pay_payroll_actions ppa_arch,
383: per_all_assignments_f paf,
384: pay_action_information pai
385: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 412: pay_assignment_actions paa_sua,

408: )
409: AND paa_arch.tax_unit_id = g_mag_gre_id
410: /*AND NOT EXISTS (SELECT 'X'
411: FROM pay_payroll_actions ppa_sua,
412: pay_assignment_actions paa_sua,
413: pay_action_interlocks lck
414: WHERE lck.locked_action_id = pai.action_context_id
415: AND lck.locking_action_id =
416: paa_sua.assignment_action_id

Line 440: FROM pay_assignment_actions paa_arch,

436: SELECT paa_arch.assignment_action_id,
437: paf.assignment_id,
438: paf.person_id,
439: ppa_arch.payroll_action_id
440: FROM pay_assignment_actions paa_arch,
441: pay_payroll_actions ppa_arch,
442: per_all_assignments_f paf,
443: pay_population_ranges ppr,
444: pay_action_information pai

Line 473: pay_assignment_actions paa_sua,

469: )
470: AND paa_arch.tax_unit_id = g_mag_gre_id
471: /*AND NOT EXISTS (SELECT 'X'
472: FROM pay_payroll_actions ppa_sua,
473: pay_assignment_actions paa_sua,
474: pay_action_interlocks lck
475: WHERE lck.locked_action_id = pai.action_context_id
476: AND lck.locking_action_id =
477: paa_sua.assignment_action_id

Line 604: SELECT pay_assignment_actions_s.nextval

600: hr_utility_trace('Current person = '||ln_person_id);
601: hr_utility_trace('Previous person = '||ln_prev_person_id);
602:
603: IF (ln_person_id <> ln_prev_person_id) THEN
604: SELECT pay_assignment_actions_s.nextval
605: INTO ln_mag_asg_act_id
606: FROM dual;
607:
608: hr_utility_trace('Creating magtape assignment action '||

Line 675: pay_assignment_actions paa_arch,

671: pai.action_context_id,
672: pai.action_information_id,
673: nvl(pai.action_information21, 'N') -- Do not report flag
674: FROM pay_action_information pai,
675: pay_assignment_actions paa_arch,
676: per_all_assignments_f paf,
677: pay_action_interlocks lck
678: WHERE pai.action_context_id = paa_arch.assignment_action_id
679: AND paf.assignment_id = paa_arch.assignment_id

Line 701: pay_assignment_actions paa_arch,

697: nvl(pai.action_information10, 'N'), -- Do not report flag
698: fnd_number.canonical_to_number(pai.action_information8), --IDW
699: pai.action_information2 -- transaction date
700: FROM pay_action_information pai,
701: pay_assignment_actions paa_arch,
702: per_all_assignments_f paf,
703: pay_action_interlocks lck
704: WHERE pai.action_context_id = paa_arch.assignment_action_id
705: AND paf.assignment_id = paa_arch.assignment_id

Line 740: FROM pay_assignment_actions paa_mag,

736: cp_person_id varchar2,
737: cp_tran_type varchar2,
738: cp_tran_dt date) IS
739: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
740: FROM pay_assignment_actions paa_mag,
741: pay_payroll_actions ppa_mag,
742: pay_assignment_actions paa_mag_prev,
743: pay_payroll_actions ppa_mag_prev,
744: pay_action_information pai,

Line 742: pay_assignment_actions paa_mag_prev,

738: cp_tran_dt date) IS
739: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
740: FROM pay_assignment_actions paa_mag,
741: pay_payroll_actions ppa_mag,
742: pay_assignment_actions paa_mag_prev,
743: pay_payroll_actions ppa_mag_prev,
744: pay_action_information pai,
745: pay_action_interlocks lck
746: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 772: FROM pay_assignment_actions paa,

768: AND ppa_mag_prev.action_status = 'C';
769:
770: CURSOR csr_person (cp_asg_act_id number) IS
771: SELECT DISTINCT paf.person_id
772: FROM pay_assignment_actions paa,
773: per_assignments_f paf
774: WHERE paf.assignment_id = paa.assignment_id
775: AND paa.assignment_action_id = cp_asg_act_id;
776:

Line 788: pay_assignment_actions paa,

784: fnd_date.canonical_to_date(
785: pay_mx_utility.get_legi_param_val('END_DATE',
786: ppa.legislative_parameters))
787: FROM pay_payroll_actions ppa,
788: pay_assignment_actions paa,
789: per_assignments_f paf
790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_id = paf.assignment_id
792: AND paf.person_id = cp_person_id

Line 821: pay_assignment_actions paa_sua,

817:
818: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
819: SELECT fnd_number.canonical_to_number(pai.action_information8)
820: FROM pay_payroll_actions ppa_sua,
821: pay_assignment_actions paa_sua,
822: pay_assignment_actions paa_arch,
823: pay_action_interlocks lck,
824: pay_action_information pai
825: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id

Line 822: pay_assignment_actions paa_arch,

818: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS
819: SELECT fnd_number.canonical_to_number(pai.action_information8)
820: FROM pay_payroll_actions ppa_sua,
821: pay_assignment_actions paa_sua,
822: pay_assignment_actions paa_arch,
823: pay_action_interlocks lck,
824: pay_action_information pai
825: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
826: AND paa_sua.assignment_action_id = lck.locking_action_id

Line 1203: FROM pay_assignment_actions paa_arch,

1199:
1200: -- Bug 4864237
1201: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1202: SELECT DISTINCT paa_arch.payroll_action_id
1203: FROM pay_assignment_actions paa_arch,
1204: pay_assignment_actions paa_mag,
1205: pay_action_interlocks lck
1206: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1207: AND lck.locking_action_id = paa_mag.assignment_action_id

Line 1204: pay_assignment_actions paa_mag,

1200: -- Bug 4864237
1201: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1202: SELECT DISTINCT paa_arch.payroll_action_id
1203: FROM pay_assignment_actions paa_arch,
1204: pay_assignment_actions paa_mag,
1205: pay_action_interlocks lck
1206: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1207: AND lck.locking_action_id = paa_mag.assignment_action_id
1208: AND paa_mag.chunk_number >= cp_chunk