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.HR_H2PI_VALIDATE dependencies on HR_H2PI_ID_MAPPING

Line 32: FROM hr_h2pi_id_mapping him,

28: FROM hr_h2pi_bg_and_gre_v bg
29: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_Id
30: AND bg.organization_id = p_organization_id
31: AND NOT EXISTS (SELECT 'X'
32: FROM hr_h2pi_id_mapping him,
33: hr_h2pi_bg_and_gre bg1
34: WHERE him.to_id = bg.organization_id
35: AND bg1.organization_id = him.from_id
36: AND him.table_name = 'HR_ALL_ORGANIZATION_UNITS'

Line 45: FROM hr_h2pi_id_mapping him

41: FROM hr_h2pi_bg_and_gre_v bg
42: WHERE bg.business_group_id = hr_h2pi_upload.g_to_business_group_id
43: AND bg.organization_id = p_organization_id
44: AND NOT EXISTS (SELECT 'X'
45: FROM hr_h2pi_id_mapping him
46: WHERE him.to_id = bg.organization_id
47: AND him.table_name = 'HR_ALL_ORGANIZATION_UNITS'
48: AND him.to_business_group_id =
49: hr_h2pi_upload.g_to_business_group_id);

Line 211: FROM hr_h2pi_id_mapping him,

207: FROM hr_h2pi_pay_bases_v pay
208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
209: AND pay.pay_basis_id = p_pay_basis_id
210: AND NOT EXISTS (SELECT 'X'
211: FROM hr_h2pi_id_mapping him,
212: hr_h2pi_pay_bases pay1
213: WHERE him.to_id = pay.pay_basis_id
214: AND pay1.pay_basis_id = him.from_id
215: AND him.table_name = 'PER_PAY_BASES'

Line 224: FROM hr_h2pi_id_mapping him

220: FROM hr_h2pi_pay_bases_v pay
221: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
222: AND pay.pay_basis_id = p_pay_basis_id
223: AND NOT EXISTS (SELECT 'X'
224: FROM hr_h2pi_id_mapping him
225: WHERE him.to_id = pay.pay_basis_id
226: AND him.table_name = 'PER_PAY_BASES'
227: AND him.to_business_group_id =
228: hr_h2pi_upload.g_to_business_group_id);

Line 366: FROM hr_h2pi_id_mapping him,

362: FROM hr_h2pi_payrolls_v pay
363: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
364: AND pay.payroll_id = p_payroll_id
365: AND NOT EXISTS (SELECT 'X'
366: FROM hr_h2pi_id_mapping him,
367: hr_h2pi_payrolls pay1
368: WHERE him.to_id = pay.payroll_id
369: AND pay1.payroll_id = him.from_id
370: AND him.table_name = 'PAY_ALL_PAYROLLS_F'

Line 379: FROM hr_h2pi_id_mapping him

375: FROM hr_h2pi_payrolls_v pay
376: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
377: AND pay.payroll_id = p_payroll_id
378: AND NOT EXISTS (SELECT 'X'
379: FROM hr_h2pi_id_mapping him
380: WHERE him.to_id = pay.payroll_id
381: AND him.table_name = 'PAY_ALL_PAYROLLS_F'
382: AND him.to_business_group_id =
383: hr_h2pi_upload.g_to_business_group_id);

Line 528: FROM hr_h2pi_id_mapping him,

524: FROM hr_h2pi_element_types_v ele
525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
526: AND ele.element_type_id = p_element_type_id
527: AND NOT EXISTS (SELECT 'X'
528: FROM hr_h2pi_id_mapping him,
529: hr_h2pi_element_types ele1
530: WHERE him.to_id = ele.element_type_id
531: AND ele1.element_type_id = him.from_id
532: AND him.table_name = 'PAY_ELEMENT_TYPES_F'

Line 541: FROM hr_h2pi_id_mapping him

537: FROM hr_h2pi_element_types_v ele
538: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
539: AND ele.element_type_id = p_element_type_id
540: AND NOT EXISTS (SELECT 'X'
541: FROM hr_h2pi_id_mapping him
542: WHERE him.to_id = ele.element_type_id
543: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
544: AND him.to_business_group_id =
545: hr_h2pi_upload.g_to_business_group_id);

Line 686: FROM hr_h2pi_id_mapping him,

682: FROM hr_h2pi_org_payment_methods_v ele
683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
684: AND ele.org_payment_method_id = p_org_payment_method_id
685: AND NOT EXISTS (SELECT 'X'
686: FROM hr_h2pi_id_mapping him,
687: hr_h2pi_org_payment_methods ele1
688: WHERE him.to_id = ele.org_payment_method_id
689: AND ele1.org_payment_method_id = him.from_id
690: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'

Line 699: FROM hr_h2pi_id_mapping him

695: FROM hr_h2pi_org_payment_methods_v ele
696: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
697: AND ele.org_payment_method_id = p_org_payment_method_id
698: AND NOT EXISTS (SELECT 'X'
699: FROM hr_h2pi_id_mapping him
700: WHERE him.to_id = ele.org_payment_method_id
701: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
702: AND him.to_business_group_id =
703: hr_h2pi_upload.g_to_business_group_id);

Line 856: FROM hr_h2pi_id_mapping him,

852: FROM hr_h2pi_element_links_v ele
853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
854: AND ele.element_link_id = p_element_link_id
855: AND NOT EXISTS (SELECT 'X'
856: FROM hr_h2pi_id_mapping him,
857: hr_h2pi_element_links ele1
858: WHERE him.to_id = ele.element_link_id
859: AND ele1.element_link_id = him.from_id
860: AND him.table_name = 'PAY_ELEMENT_LINKS_F'

Line 869: FROM hr_h2pi_id_mapping him

865: FROM hr_h2pi_element_links_v ele
866: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
867: AND ele.element_link_id = p_element_link_id
868: AND NOT EXISTS (SELECT 'X'
869: FROM hr_h2pi_id_mapping him
870: WHERE him.to_id = ele.element_link_id
871: AND him.table_name = 'PAY_ELEMENT_LINKS_F'
872: AND him.to_business_group_id =
873: hr_h2pi_upload.g_to_business_group_id);