DBA Data[Home] [Help]

APPS.PER_PERSACTR_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

29: RETURN V_BUSINESS_GROUP;
30: END CF_BUSINESS_GROUPFORMULA;
31:
32: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
33: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
34: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
35: SELECT
36: ORG_INFORMATION9
37: FROM

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

30: END CF_BUSINESS_GROUPFORMULA;
31:
32: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
33: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
34: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
35: SELECT
36: ORG_INFORMATION9
37: FROM
38: HR_ORGANIZATION_INFORMATION

Line 38: HR_ORGANIZATION_INFORMATION

34: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
35: SELECT
36: ORG_INFORMATION9
37: FROM
38: HR_ORGANIZATION_INFORMATION
39: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
40: AND ORG_INFORMATION9 is not null
41: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
42: BEGIN