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;
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