13: END CF_BUSINESS_GROUPFORMULA;
14:
15: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
16: CODE VARCHAR2(1);
17: FLAG HR_LOOKUPS.MEANING%TYPE;
18: CURSOR C_CUR_FUT IS
19: SELECT
20: LOOKUP_CODE,
21: MEANING
19: SELECT
20: LOOKUP_CODE,
21: MEANING
22: FROM
23: HR_LOOKUPS
24: WHERE LOOKUP_CODE in ( 'C' , 'F' )
25: AND LOOKUP_TYPE = 'AU_ADV_FLAG';
26: CURSOR C_PROCESS IS
27: SELECT
27: SELECT
28: LOOKUP_CODE,
29: MEANING
30: FROM
31: HR_LOOKUPS
32: WHERE LOOKUP_CODE in ( 'Y' , 'N' )
33: AND LOOKUP_TYPE = 'YES_NO';
34: CURSOR C_GET_EMP_NO IS
35: SELECT