APPS.HRI_OLTP_PMV_ABS_DTL dependencies on HRI_BPL_UTILIZATION

Line 77: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN

73: END LOOP;
74:
75: /* formulate the dynmaic column selection based on Absence Duration
76: unit of measure profile option */
77: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
78: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';
79: l_dynmc_drtn := 'abs_cs.abs_drtn_days';
80: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
81: l_dynmc_drtn_prd := 'factM.abs_drtn_hrs_prd';

Line 80: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

76: unit of measure profile option */
77: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
78: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';
79: l_dynmc_drtn := 'abs_cs.abs_drtn_days';
80: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
81: l_dynmc_drtn_prd := 'factM.abs_drtn_hrs_prd';
82: l_dynmc_drtn := 'abs_cs.abs_drtn_hrs';
83: ELSE -- functional decision (JC) default to days
84: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';

Line 229: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN

225: END LOOP;
226:
227: /* formulate the dynmaic column selection based on Absence Duration
228: unit of measure profile option */
229: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
230: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';
231: l_dynmc_drtn := 'abs_cs.abs_drtn_days';
232: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
233: l_dynmc_drtn_prd := 'factM.abs_drtn_hrs_prd';

Line 232: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

228: unit of measure profile option */
229: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
230: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';
231: l_dynmc_drtn := 'abs_cs.abs_drtn_days';
232: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
233: l_dynmc_drtn_prd := 'factM.abs_drtn_hrs_prd';
234: l_dynmc_drtn := 'abs_cs.abs_drtn_hrs';
235: ELSE -- functional decision (JC) default to days
236: l_dynmc_drtn_prd := 'factM.abs_drtn_days_prd';