DBA Data[Home] [Help]

APPS.PER_PERSAIQE_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 22: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;

18: RETURN V_BUSINESS_GROUP;
19: END CF_BUSINESS_GROUPFORMULA;
20:
21: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
22: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
23: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
24: SELECT
25: ORG_INFORMATION9
26: FROM

Line 23: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS

19: END CF_BUSINESS_GROUPFORMULA;
20:
21: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
22: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
23: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
24: SELECT
25: ORG_INFORMATION9
26: FROM
27: HR_ORGANIZATION_INFORMATION

Line 27: HR_ORGANIZATION_INFORMATION

23: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
24: SELECT
25: ORG_INFORMATION9
26: FROM
27: HR_ORGANIZATION_INFORMATION
28: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
29: AND ORG_INFORMATION9 is not null
30: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
31: BEGIN