DBA Data[Home] [Help]

APPS.PAY_PYAURECD_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

250: RETURN V_BUSINESS_GROUP;
251: END CF_BUSINESS_GROUPFORMULA;
252:
253: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
254: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
255: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
256: SELECT
257: ORG_INFORMATION9
258: FROM

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

251: END CF_BUSINESS_GROUPFORMULA;
252:
253: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
254: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
255: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
256: SELECT
257: ORG_INFORMATION9
258: FROM
259: HR_ORGANIZATION_INFORMATION

Line 259: HR_ORGANIZATION_INFORMATION

255: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
256: SELECT
257: ORG_INFORMATION9
258: FROM
259: HR_ORGANIZATION_INFORMATION
260: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
261: AND ORG_INFORMATION9 is not null
262: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
263: BEGIN