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_ACTION_INFORMATION

Line 67: Removed pay_action_information

63: vmehta 09-Nov-2005 115.14 Increased the size of lv_buf
64: in multiple places to allow for
65: multibyte characterset expansion.
66: vmehta 23-Nov-2005 115.15 Modified get_arch_pact_id.
67: Removed pay_action_information
68: from the list of tables.
69: sdahiya 21-NOV-2005 115.16 4773967 CLOB to BLOB changes.
70: sdahiya 01-DEC-2005 115.17 Modified PRINT_BLOB to use
71: pay_ac_utility.print_lob.

Line 126: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type

122:
123: --
124: -- Global Variables
125: --
126: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type
127: INDEX BY BINARY_INTEGER;
128: g_xml_cache char_tab;
129: g_proc_name varchar2(240);
130: g_debug boolean;

Line 384: pay_action_information pai

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
387: -- Bug 4518777
388: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id

Line 444: pay_action_information pai

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
446: AND paa_arch.assignment_id = paf.assignment_id
447: AND paf.person_id = ppr.person_id
448: AND ppr.chunk_number = p_chunk

Line 674: FROM pay_action_information pai,

670: SELECT paa_arch.payroll_action_id,
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

Line 700: FROM pay_action_information pai,

696: pai.effective_date,
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

Line 744: pay_action_information pai,

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
748: AND pay_mx_utility.get_legi_param_val ('GRE',

Line 824: pay_action_information pai

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
827: AND lck.locked_action_id = paa_arch.assignment_action_id
828: AND paa_arch.assignment_action_id = pai.action_context_id

Line 870: lv_tran_type pay_action_information.action_information4%type;

866: FROM hr_organization_units hou
867: WHERE hou.organization_id = g_mag_gre_id;
868:
869: l_proc_name varchar2(100);
870: lv_tran_type pay_action_information.action_information4%type;
871: lv_person_id pay_action_information.action_information1%type;
872: lv_tran_dt pay_action_information.action_information2%type;
873: ln_tax_unit_id number;
874: ld_effective_date date;

Line 871: lv_person_id pay_action_information.action_information1%type;

867: WHERE hou.organization_id = g_mag_gre_id;
868:
869: l_proc_name varchar2(100);
870: lv_tran_type pay_action_information.action_information4%type;
871: lv_person_id pay_action_information.action_information1%type;
872: lv_tran_dt pay_action_information.action_information2%type;
873: ln_tax_unit_id number;
874: ld_effective_date date;
875: ld_tran_dt date;

Line 872: lv_tran_dt pay_action_information.action_information2%type;

868:
869: l_proc_name varchar2(100);
870: lv_tran_type pay_action_information.action_information4%type;
871: lv_person_id pay_action_information.action_information1%type;
872: lv_tran_dt pay_action_information.action_information2%type;
873: ln_tax_unit_id number;
874: ld_effective_date date;
875: ld_tran_dt date;
876: ln_payroll_action_id number;

Line 1214: FROM pay_action_information pai

1210: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1211:
1212: CURSOR get_action_info_id (cp_action_context_id number) IS
1213: SELECT pai.action_information_id
1214: FROM pay_action_information pai
1215: WHERE pai.action_context_id = cp_action_context_id
1216: AND pai.action_context_type = 'PA'
1217: AND pai.action_information_category = 'MX SS GRE INFORMATION';
1218: