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 144: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type

140:
141: --
142: -- Global Variables
143: --
144: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type
145: INDEX BY BINARY_INTEGER;
146: g_xml_cache char_tab;
147: g_proc_name varchar2(240);
148: g_debug boolean;

Line 413: pay_action_information pai

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

Line 484: pay_action_information pai

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
486: AND paa_arch.assignment_id = paf.assignment_id
487: AND paf.person_id = ppr.person_id
488: AND ppr.chunk_number = p_chunk

Line 781: FROM pay_action_information pai,

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

Line 812: FROM pay_action_information pai,

808: nvl(pai.action_information10, 'N'), -- Do not report flag
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

Line 859: pay_action_information pai,

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

Line 939: pay_action_information pai

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

Line 985: lv_tran_type pay_action_information.action_information4%type;

981: FROM hr_organization_units hou
982: WHERE hou.organization_id = g_mag_gre_id;
983:
984: l_proc_name varchar2(100);
985: lv_tran_type pay_action_information.action_information4%type;
986: lv_person_id pay_action_information.action_information1%type;
987: lv_tran_dt pay_action_information.action_information2%type;
988: ln_tax_unit_id number;
989: ld_effective_date date;

Line 986: lv_person_id pay_action_information.action_information1%type;

982: WHERE hou.organization_id = g_mag_gre_id;
983:
984: l_proc_name varchar2(100);
985: lv_tran_type pay_action_information.action_information4%type;
986: lv_person_id pay_action_information.action_information1%type;
987: lv_tran_dt pay_action_information.action_information2%type;
988: ln_tax_unit_id number;
989: ld_effective_date date;
990: ld_tran_dt date;

Line 987: lv_tran_dt pay_action_information.action_information2%type;

983:
984: l_proc_name varchar2(100);
985: lv_tran_type pay_action_information.action_information4%type;
986: lv_person_id pay_action_information.action_information1%type;
987: lv_tran_dt pay_action_information.action_information2%type;
988: ln_tax_unit_id number;
989: ld_effective_date date;
990: ld_tran_dt date;
991: ln_payroll_action_id number;

Line 1342: FROM pay_action_information pai

1338: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1339:
1340: CURSOR get_action_info_id (cp_action_context_id number) IS
1341: SELECT pai.action_information_id
1342: FROM pay_action_information pai
1343: WHERE pai.action_context_id = cp_action_context_id
1344: AND pai.action_context_type = 'PA'
1345: AND pai.action_information_category = 'MX SS GRE INFORMATION';
1346: