DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 19: HR_ORGANIZATION_INFORMATION OI

15: CURSOR ORG_EIN IS
16: SELECT
17: OI.ORG_INFORMATION1
18: FROM
19: HR_ORGANIZATION_INFORMATION OI
20: WHERE OI.ORGANIZATION_ID = P_ORGANIZATION_ID
21: AND OI.ORG_INFORMATION_CONTEXT = 'Employer Identification';
22: CURSOR MASTER_ORG_EIN IS
23: SELECT

Line 27: HR_ORGANIZATION_INFORMATION MOI

23: SELECT
24: MOI.ORG_INFORMATION1
25: FROM
26: MTL_PARAMETERS MP,
27: HR_ORGANIZATION_INFORMATION MOI
28: WHERE MP.ORGANIZATION_ID = P_ORGANIZATION_ID
29: AND MP.MASTER_ORGANIZATION_ID = MOI.ORGANIZATION_ID
30: AND MOI.ORG_INFORMATION_CONTEXT = 'Employer Identification';
31: CURSOR STRUCT_NUM(FLEX_CODE IN VARCHAR2) IS