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_SE_EFT dependencies on HR_ORGANIZATION_INFORMATION

Line 78: hr_organization_information hoi2,

74: PAY_ORG_PAYMENT_METHODS_F ppm,
75: pay_external_Accounts pea,
76: hr_soft_coding_keyflex hsk,
77: pay_all_payrolls_f pap,
78: hr_organization_information hoi2,
79: hr_organization_information hoi3,
80: hr_organization_information hoi4
81: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
82: and ppa.business_group_id =ou.business_group_id

Line 79: hr_organization_information hoi3,

75: pay_external_Accounts pea,
76: hr_soft_coding_keyflex hsk,
77: pay_all_payrolls_f pap,
78: hr_organization_information hoi2,
79: hr_organization_information hoi3,
80: hr_organization_information hoi4
81: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
82: and ppa.business_group_id =ou.business_group_id
83: and paf.business_group_id=ou.business_group_id

Line 80: hr_organization_information hoi4

76: hr_soft_coding_keyflex hsk,
77: pay_all_payrolls_f pap,
78: hr_organization_information hoi2,
79: hr_organization_information hoi3,
80: hr_organization_information hoi4
81: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
82: and ppa.business_group_id =ou.business_group_id
83: and paf.business_group_id=ou.business_group_id
84: and ppp.pre_payment_id = paa.pre_payment_id

Line 108: hr_organization_information

104: and hoi4.ORG_INFORMATION_CONTEXT = 'SE_ORG_CONTACT_DETAILS'
105: and hoi4.org_information1='PHONE'
106: and hoi4.org_information_id=(select
107: min(org_information_id)from
108: hr_organization_information
109: where organization_id = ou.organization_id
110: and ORG_INFORMATION_CONTEXT = 'SE_ORG_CONTACT_DETAILS'
111: and org_information1='PHONE' )
112: and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID

Line 158: , HR_ORGANIZATION_INFORMATION hoi1

154: and hsk.segment2 in
155: (
156: select hoi2.org_information1
157: from HR_ORGANIZATION_UNITS o1
158: , HR_ORGANIZATION_INFORMATION hoi1
159: , HR_ORGANIZATION_INFORMATION hoi2
160: WHERE o1.business_group_id = ppa.business_group_id
161: and o1.organization_id = hoi1.organization_id
162: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 159: , HR_ORGANIZATION_INFORMATION hoi2

155: (
156: select hoi2.org_information1
157: from HR_ORGANIZATION_UNITS o1
158: , HR_ORGANIZATION_INFORMATION hoi1
159: , HR_ORGANIZATION_INFORMATION hoi2
160: WHERE o1.business_group_id = ppa.business_group_id
161: and o1.organization_id = hoi1.organization_id
162: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
163: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'