DBA Data[Home] [Help]

APPS.PAY_PAYKRHCL_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 37: V_BUSINESS_GROUP HR_ORGANIZATION_UNITS.NAME%TYPE;

33: RETURN (TRUE);
34: END AFTERREPORT;
35:
36: FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2 IS
37: V_BUSINESS_GROUP HR_ORGANIZATION_UNITS.NAME%TYPE;
38: BEGIN
39: V_BUSINESS_GROUP := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
40: RETURN V_BUSINESS_GROUP;
41: END CF_BUSINESS_GROUPFORMULA;

Line 161: HR_ORGANIZATION_UNITS HOU1,

157: CURSOR BP_NAMES IS
158: SELECT
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