APPS.PAY_PYAUFBR_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

24: RETURN (TRUE);
25: END BEFOREREPORT;
26:
27: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
28: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
29: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
30: SELECT
31: ORG_INFORMATION9
32: FROM

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

25: END BEFOREREPORT;
26:
27: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
28: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
29: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
30: SELECT
31: ORG_INFORMATION9
32: FROM
33: HR_ORGANIZATION_INFORMATION

Line 33: HR_ORGANIZATION_INFORMATION

29: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
30: SELECT
31: ORG_INFORMATION9
32: FROM
33: HR_ORGANIZATION_INFORMATION
34: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
35: AND ORG_INFORMATION9 is not null
36: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
37: BEGIN