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 208: FROM pay_payroll_actions ppa_mag

204: pay_mx_utility.get_legi_param_val('END_DATE',
205: ppa_mag.legislative_parameters),
206: pay_mx_utility.get_legi_param_val('MODE',
207: ppa_mag.legislative_parameters)
208: FROM pay_payroll_actions ppa_mag
209: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
210:
211: l_proc_name varchar2(100);
212: BEGIN

Line 254: FROM pay_payroll_actions ppa

250: fnd_date.canonical_to_date(
251: pay_mx_utility.get_legi_param_val ('END_DATE',
252: ppa.legislative_parameters)) +
253: 1/(24 * 60 * 60))
254: FROM pay_payroll_actions ppa
255: WHERE pay_mx_utility.get_legi_param_val('GRE',
256: ppa.legislative_parameters) =
257: p_gre_id
258: AND ppa.report_type = 'SUA_MAG'

Line 342: pay_payroll_actions ppa_arch

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

Line 382: pay_payroll_actions ppa_arch,

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

Line 411: FROM pay_payroll_actions ppa_sua,

407: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
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 =

Line 441: pay_payroll_actions ppa_arch,

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

Line 472: FROM pay_payroll_actions ppa_sua,

468: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
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 =

Line 498: FROM pay_payroll_actions ppa

494: paf.effective_end_date;
495:
496: CURSOR csr_future_magtape_exists IS
497: SELECT 'Y'
498: FROM pay_payroll_actions ppa
499: WHERE ppa.report_type = 'SUA_MAG'
500: AND ppa.report_qualifier = 'SUA_MAG'
501: AND ppa.report_category = 'RT'
502: AND ppa.action_type = 'X'

Line 741: pay_payroll_actions ppa_mag,

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

Line 743: pay_payroll_actions ppa_mag_prev,

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

Line 787: FROM pay_payroll_actions ppa,

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

Line 820: FROM pay_payroll_actions ppa_sua,

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