APPS.PAY_PAYKRHCL_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

40: RETURN V_BUSINESS_GROUP;
41: END CF_BUSINESS_GROUPFORMULA;
42:
43: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
44: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
45: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
46: SELECT
47: ORG_INFORMATION9
48: FROM

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

41: END CF_BUSINESS_GROUPFORMULA;
42:
43: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
44: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
45: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
46: SELECT
47: ORG_INFORMATION9
48: FROM
49: HR_ORGANIZATION_INFORMATION

Line 49: HR_ORGANIZATION_INFORMATION

45: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
46: SELECT
47: ORG_INFORMATION9
48: FROM
49: HR_ORGANIZATION_INFORMATION
50: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
51: AND ORG_INFORMATION9 is not null
52: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
53: BEGIN

Line 163: HR_ORGANIZATION_INFORMATION HOI2

159: HOU1.NAME
160: FROM
161: HR_ORGANIZATION_UNITS HOU1,
162: PAY_PAYROLL_ACTIONS PPA,
163: HR_ORGANIZATION_INFORMATION HOI2
164: WHERE PPA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
165: AND HOU1.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID
166: AND HOU1.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
167: AND HOI2.ORG_INFORMATION_CONTEXT = 'KR_HI_INFORMATION'