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_PAYROLL_ACTIONS

Line 31: pay_payroll_actions instead of

27: column to get person_id.
28:
29: 4518732 Modified get_start_date to read
30: the start date from
31: pay_payroll_actions instead of
32: pay_recorded_requests. This will
33: facilitate rollbacks of SUA
34: Interface Extract concurrent
35: program.

Line 226: FROM pay_payroll_actions ppa_mag

222: pay_mx_utility.get_legi_param_val('END_DATE',
223: ppa_mag.legislative_parameters),
224: pay_mx_utility.get_legi_param_val('MODE',
225: ppa_mag.legislative_parameters)
226: FROM pay_payroll_actions ppa_mag
227: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
228:
229: l_proc_name varchar2(100);
230: BEGIN

Line 272: FROM pay_payroll_actions ppa

268: fnd_date.canonical_to_date(
269: pay_mx_utility.get_legi_param_val ('END_DATE',
270: ppa.legislative_parameters)) +
271: 1/(24 * 60 * 60))
272: FROM pay_payroll_actions ppa
273: WHERE pay_mx_utility.get_legi_param_val('GRE',
274: ppa.legislative_parameters) =
275: p_gre_id
276: AND ppa.report_type = 'SUA_MAG'

Line 370: pay_payroll_actions ppa_arch

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'',
374: ppa_arch.legislative_parameters))

Line 411: pay_payroll_actions ppa_arch,

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
415: AND paa_arch.assignment_id = paf.assignment_id

Line 450: FROM pay_payroll_actions ppa_sua,

446: )
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 =

Line 481: pay_payroll_actions ppa_arch,

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
485: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id

Line 522: FROM pay_payroll_actions ppa_sua,

518: )
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 =

Line 548: FROM pay_payroll_actions ppa

544: paf.effective_end_date;
545:
546: CURSOR csr_future_magtape_exists IS
547: SELECT 'Y'
548: FROM pay_payroll_actions ppa
549: WHERE ppa.report_type = 'SUA_MAG'
550: AND ppa.report_qualifier = 'SUA_MAG'
551: AND ppa.report_category = 'RT'
552: AND ppa.action_type = 'X'

Line 574: FROM pay_payroll_actions pact,

570: the archiver assignment action has already been locked by another
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

Line 856: pay_payroll_actions ppa_mag,

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,
860: pay_action_interlocks lck

Line 858: pay_payroll_actions ppa_mag_prev,

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
862: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id

Line 902: FROM pay_payroll_actions ppa,

898: SELECT paa.assignment_action_id,
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

Line 935: FROM pay_payroll_actions ppa_sua,

931: ORDER BY 2 DESC;
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