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

Line 156: hr_organization_information hoi

152: Select
153: decode(hoi.org_information3,'N','Z',hoi.org_information3) flag ,hoi.org_information1
154: From
155: hr_all_organization_units haou,
156: hr_organization_information hoi
157: Where haou.organization_id = c_establishment_id
158: and haou.organization_id = hoi.organization_id
159: and hoi.org_information_context = 'FR_ESTAB_PE_PRVS'
160: and exists

Line 163: hr_organization_information hoi1

159: and hoi.org_information_context = 'FR_ESTAB_PE_PRVS'
160: and exists
161: (Select 1
162: From
163: hr_organization_information hoi1
164: Where hoi1.organization_id = hoi.org_information1
165: and hoi1.org_information_context = 'FR_PE_PRV_INFO'
166: and hoi1.org_information2 = c_type
167: ) ;