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.PER_MX_SS_AFFILIATION dependencies on PAY_ACTION_INFORMATION

Line 440: pay_action_information pai

436: pai.action_context_id,
437: paf.primary_flag,
438: pai.tax_unit_id
439: FROM per_assignments_f paf,
440: pay_action_information pai
441: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
442: AND paf.business_group_id = g_business_group
443: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
444: AND paf.person_id = pai.action_information1

Line 493: pay_action_information pai,

489: pai.action_context_id,
490: paf.primary_flag,
491: pai.tax_unit_id
492: FROM per_assignments_f paf,
493: pay_action_information pai,
494: pay_population_ranges ppr
495: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
496: AND paf.business_group_id = g_business_group
497: AND ppr.payroll_action_id = p_payroll_action_id

Line 782: pay_action_information pai

778: FROM pay_payroll_actions ppa_mag,
779: pay_assignment_actions paa_mag,
780: --pay_assignment_actions paa_arch,
781: pay_action_interlocks lck,
782: pay_action_information pai
783: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id
784: AND paa_mag.assignment_action_id = lck.locking_action_id
785: /*AND lck.locked_action_id = paa_arch.assignment_action_id
786: AND paa_arch.assignment_action_id = pai.action_context_id*/

Line 828: lv_hire_date pay_action_information.action_information2%TYPE;

824: ln_cntr NUMBER;
825: ln_prev_idw NUMBER;
826: ln_hire_idx NUMBER;
827: ln_term_idx NUMBER;
828: lv_hire_date pay_action_information.action_information2%TYPE;
829: BEGIN
830: l_proc_name := g_proc_name || 'PROCESS_TRANSACTIONS';
831: hr_utility_trace ('Entering '||l_proc_name);
832:

Line 983: FROM pay_action_information pai /*,

979: -- Bug 5919339
980: fnd_number.canonical_to_number(pai.action_information11), -- IDW
981: pai.action_information18 -- Salary Type
982: -- Bug 6065124
983: FROM pay_action_information pai /*,
984: pay_assignment_actions paa_arch,
985: pay_action_interlocks lck*/
986: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
987: /*and lck.locking_action_id = cp_assignment_action_id

Line 1009: pay_action_information pai,

1005: pay_mx_utility.get_legi_param_val('END_DATE',
1006: ppa.legislative_parameters))
1007: FROM pay_payroll_actions ppa,
1008: pay_assignment_actions paa,
1009: pay_action_information pai,
1010: pay_action_interlocks lck
1011: WHERE paa.payroll_action_id = ppa.payroll_action_id
1012: AND paa.assignment_action_id = lck.locking_action_id
1013: AND pai.action_context_id = lck.locked_action_id

Line 1032: FROM pay_action_information pai

1028:
1029:
1030: SELECT pai.action_context_id,
1031: pai.effective_date
1032: FROM pay_action_information pai
1033: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
1034: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
1035: -- Bug 6060070
1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)

Line 1078: FROM pay_action_information pai,

1074: pai.action_information5, -- Employer SS ID
1075: fnd_number.canonical_to_number (pai.action_information8), -- IDW
1076: pai.action_information9, -- Leaving reason
1077: pai.action_information24 -- Reporting option (YES/NO)
1078: FROM pay_action_information pai,
1079: pay_action_interlocks lck
1080: WHERE lck.locking_action_id = cp_assignment_action_id
1081: AND lck.locked_action_id = pai.action_context_id
1082: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 1145: lv_person_id pay_action_information.action_information1%type;

1141: lt_tran transactions;
1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;

Line 1146: lv_name pay_action_information.action_information7%type;

1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;

Line 1147: lv_worker_type pay_action_information.action_information8%type;

1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;

Line 1148: lv_rww pay_action_information.action_information9%type;

1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;

Line 1149: lv_hire_date pay_action_information.action_information10%type;

1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;

Line 1150: lv_salary_type pay_action_information.action_information18%type;

1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;

Line 1152: lv_tran_dt pay_action_information.action_information2%type;

1148: lv_rww pay_action_information.action_information9%type;
1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;
1155: lv_er_ssid pay_action_information.action_information5%type;
1156: lv_leaving_reason pay_action_information.action_information9%type;

Line 1153: lv_ee_ssn pay_action_information.action_information3%type;

1149: lv_hire_date pay_action_information.action_information10%type;
1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;
1155: lv_er_ssid pay_action_information.action_information5%type;
1156: lv_leaving_reason pay_action_information.action_information9%type;
1157: ln_legal_er NUMBER;

Line 1154: lv_tran_type pay_action_information.action_information4%type;

1150: lv_salary_type pay_action_information.action_information18%type;
1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;
1155: lv_er_ssid pay_action_information.action_information5%type;
1156: lv_leaving_reason pay_action_information.action_information9%type;
1157: ln_legal_er NUMBER;
1158: ld_imp_date varchar2(30);

Line 1155: lv_er_ssid pay_action_information.action_information5%type;

1151: ln_idw number;
1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;
1155: lv_er_ssid pay_action_information.action_information5%type;
1156: lv_leaving_reason pay_action_information.action_information9%type;
1157: ln_legal_er NUMBER;
1158: ld_imp_date varchar2(30);
1159: ld_event_strt_date VARCHAR2 (30);

Line 1156: lv_leaving_reason pay_action_information.action_information9%type;

1152: lv_tran_dt pay_action_information.action_information2%type;
1153: lv_ee_ssn pay_action_information.action_information3%type;
1154: lv_tran_type pay_action_information.action_information4%type;
1155: lv_er_ssid pay_action_information.action_information5%type;
1156: lv_leaving_reason pay_action_information.action_information9%type;
1157: ln_legal_er NUMBER;
1158: ld_imp_date varchar2(30);
1159: ld_event_strt_date VARCHAR2 (30);
1160: lv_report_yes_no VARCHAR2(4);

Line 1378: FROM pay_action_information pai,

1374: PROCEDURE GEN_XML_FOOTER AS
1375:
1376: CURSOR csr_employer IS
1377: SELECT pai.action_information_id
1378: FROM pay_action_information pai,
1379: pay_action_interlocks lck,
1380: pay_assignment_actions paa_affl,
1381: pay_assignment_actions paa_arch
1382: WHERE paa_affl.payroll_action_id =