DBA Data[Home] [Help]

APPS.PAY_PAYIEP30_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

92: RETURN V_BUSINESS_GROUP;
93: END CF_BUSINESS_GROUPFORMULA;
94:
95: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
96: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
97: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
98: SELECT
99: ORG_INFORMATION9
100: FROM

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

93: END CF_BUSINESS_GROUPFORMULA;
94:
95: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
96: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
97: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
98: SELECT
99: ORG_INFORMATION9
100: FROM
101: HR_ORGANIZATION_INFORMATION

Line 101: HR_ORGANIZATION_INFORMATION

97: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
98: SELECT
99: ORG_INFORMATION9
100: FROM
101: HR_ORGANIZATION_INFORMATION
102: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
103: AND ORG_INFORMATION9 is not null
104: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
105: BEGIN