DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 67: HR_ORGANIZATION_INFORMATION HOI

63: SELECT
64: ORG_INFORMATION3
65: FROM
66: HR_ORGANIZATION_UNITS HOU,
67: HR_ORGANIZATION_INFORMATION HOI
68: WHERE HOI.ORGANIZATION_ID = P_LEGAL_EMPLOYER_LP
69: AND HOI.ORG_INFORMATION2 = P_TAX_STATE_LP
70: AND HOI.ORG_INFORMATION_CONTEXT = 'AU_PAYROLL_TAX_DGE';
71:

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

166: RETURN (TRUE);
167: END BEFOREREPORT;
168:
169: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
170: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
171: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
172: SELECT
173: ORG_INFORMATION9
174: FROM

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

167: END BEFOREREPORT;
168:
169: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
170: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
171: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
172: SELECT
173: ORG_INFORMATION9
174: FROM
175: HR_ORGANIZATION_INFORMATION

Line 175: HR_ORGANIZATION_INFORMATION

171: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
172: SELECT
173: ORG_INFORMATION9
174: FROM
175: HR_ORGANIZATION_INFORMATION
176: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
177: AND ORG_INFORMATION9 is not null
178: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
179: BEGIN