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 409: pay_action_information pai

405: pai.action_context_id,
406: paf.primary_flag,
407: pai.tax_unit_id
408: FROM per_assignments_f paf,
409: pay_action_information pai
410: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
411: AND paf.business_group_id = g_business_group
412: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
413: AND paf.person_id = pai.action_information1

Line 458: pay_action_information pai,

454: pai.action_context_id,
455: paf.primary_flag,
456: pai.tax_unit_id
457: FROM per_assignments_f paf,
458: pay_action_information pai,
459: pay_population_ranges ppr
460: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
461: AND paf.business_group_id = g_business_group
462: AND ppr.payroll_action_id = p_payroll_action_id

Line 675: pay_action_information pai

671: FROM pay_payroll_actions ppa_mag,
672: pay_assignment_actions paa_mag,
673: --pay_assignment_actions paa_arch,
674: pay_action_interlocks lck,
675: pay_action_information pai
676: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id
677: AND paa_mag.assignment_action_id = lck.locking_action_id
678: /*AND lck.locked_action_id = paa_arch.assignment_action_id
679: AND paa_arch.assignment_action_id = pai.action_context_id*/

Line 714: lv_hire_date pay_action_information.action_information2%TYPE;

710: ln_cntr NUMBER;
711: ln_prev_idw NUMBER;
712: ln_hire_idx NUMBER;
713: ln_term_idx NUMBER;
714: lv_hire_date pay_action_information.action_information2%TYPE;
715: BEGIN
716: l_proc_name := g_proc_name || 'PROCESS_TRANSACTIONS';
717: hr_utility_trace ('Entering '||l_proc_name);
718:

Line 833: FROM pay_action_information pai /*,

829: -- Bug 5919339
830: fnd_number.canonical_to_number(pai.action_information11), -- IDW
831: pai.action_information18 -- Salary Type
832: -- Bug 6065124
833: FROM pay_action_information pai /*,
834: pay_assignment_actions paa_arch,
835: pay_action_interlocks lck*/
836: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
837: /*and lck.locking_action_id = cp_assignment_action_id

Line 859: pay_action_information pai,

855: pay_mx_utility.get_legi_param_val('END_DATE',
856: ppa.legislative_parameters))
857: FROM pay_payroll_actions ppa,
858: pay_assignment_actions paa,
859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa.payroll_action_id = ppa.payroll_action_id
862: AND paa.assignment_action_id = lck.locking_action_id
863: AND pai.action_context_id = lck.locked_action_id

Line 882: FROM pay_action_information pai

878:
879:
880: SELECT pai.action_context_id,
881: pai.effective_date
882: FROM pay_action_information pai
883: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
884: AND pai.action_information1 = cp_person_id
885: -- Bug 6060070
886: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)

Line 925: FROM pay_action_information pai,

921: pai.action_information4, -- Type of Transaction
922: pai.action_information5, -- Employer SS ID
923: fnd_number.canonical_to_number (pai.action_information8), -- IDW
924: pai.action_information9 -- Leaving reason
925: FROM pay_action_information pai,
926: pay_action_interlocks lck
927: WHERE lck.locking_action_id = cp_assignment_action_id
928: AND lck.locked_action_id = pai.action_context_id
929: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 989: lv_person_id pay_action_information.action_information1%type;

985: lt_tran transactions;
986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;

Line 990: lv_name pay_action_information.action_information7%type;

986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;

Line 991: lv_worker_type pay_action_information.action_information8%type;

987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;

Line 992: lv_rww pay_action_information.action_information9%type;

988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;

Line 993: lv_hire_date pay_action_information.action_information10%type;

989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;

Line 994: lv_salary_type pay_action_information.action_information18%type;

990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;

Line 996: lv_tran_dt pay_action_information.action_information2%type;

992: lv_rww pay_action_information.action_information9%type;
993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;
999: lv_er_ssid pay_action_information.action_information5%type;
1000: lv_leaving_reason pay_action_information.action_information9%type;

Line 997: lv_ee_ssn pay_action_information.action_information3%type;

993: lv_hire_date pay_action_information.action_information10%type;
994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;
999: lv_er_ssid pay_action_information.action_information5%type;
1000: lv_leaving_reason pay_action_information.action_information9%type;
1001: ln_legal_er NUMBER;

Line 998: lv_tran_type pay_action_information.action_information4%type;

994: lv_salary_type pay_action_information.action_information18%type;
995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;
999: lv_er_ssid pay_action_information.action_information5%type;
1000: lv_leaving_reason pay_action_information.action_information9%type;
1001: ln_legal_er NUMBER;
1002: ld_imp_date varchar2(30);

Line 999: lv_er_ssid pay_action_information.action_information5%type;

995: ln_idw number;
996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;
999: lv_er_ssid pay_action_information.action_information5%type;
1000: lv_leaving_reason pay_action_information.action_information9%type;
1001: ln_legal_er NUMBER;
1002: ld_imp_date varchar2(30);
1003: ld_event_strt_date VARCHAR2 (30);

Line 1000: lv_leaving_reason pay_action_information.action_information9%type;

996: lv_tran_dt pay_action_information.action_information2%type;
997: lv_ee_ssn pay_action_information.action_information3%type;
998: lv_tran_type pay_action_information.action_information4%type;
999: lv_er_ssid pay_action_information.action_information5%type;
1000: lv_leaving_reason pay_action_information.action_information9%type;
1001: ln_legal_er NUMBER;
1002: ld_imp_date varchar2(30);
1003: ld_event_strt_date VARCHAR2 (30);
1004:

Line 1203: FROM pay_action_information pai,

1199: PROCEDURE GEN_XML_FOOTER AS
1200:
1201: CURSOR csr_employer IS
1202: SELECT pai.action_information_id
1203: FROM pay_action_information pai,
1204: pay_action_interlocks lck,
1205: pay_assignment_actions paa_affl,
1206: pay_assignment_actions paa_arch
1207: WHERE paa_affl.payroll_action_id =