DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 7599: FROM hr_all_organization_units hou,

7595: NVL (TRIM (RPAD (hl.TELEPHONE_NUMBER_1, 12)), ' ' ), -- ('CONTACT_NUMBER=P'),
7596: NVL (TRIM (RPAD (hl.TELEPHONE_NUMBER_2, 12)), ' ') --('FAX_NO=P') /*Added for bug fix 3815830*/
7597: , NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') -- 10277535
7598: , NVL (TRIM (RPAD (hoi3.ORG_INFORMATION2, 30)), ' ') -- 12556436 EMAIL ADDRESS
7599: FROM hr_all_organization_units hou,
7600: hr_locations hl,
7601: pay_payroll_actions ppa,
7602: hr_organization_information hoi1,
7603: hr_organization_information hoi2