APPS.PAY_SE_ABSENCE dependencies on CAC_SR_SCHEDULES_B

Line 3232: CAC_SR_SCHEDULES_B CSSB

3228: IS
3229: SELECT CSSB.SCHEDULE_ID
3230: from
3231: CAC_SR_SCHDL_OBJECTS CSSO,
3232: CAC_SR_SCHEDULES_B CSSB
3233: where
3234: CSSO.OBJECT_TYPE = b_object_type
3235: AND CSSO.OBJECT_ID = b_object_id
3236: AND CSSO.START_DATE_ACTIVE <= b_end_dt

Line 3249: select CSTB.Template_Id,CSTB.TEMPLATE_LENGTH_DAYS from CAC_SR_SCHEDULES_B CSSB,

3245: AND b_schdl_cat IS NULL
3246: ));
3247: CURSOR csr_get_template_details(b_schedule_id number)
3248: IS
3249: select CSTB.Template_Id,CSTB.TEMPLATE_LENGTH_DAYS from CAC_SR_SCHEDULES_B CSSB,
3250: CAC_SR_TEMPLATES_B CSTB
3251: where
3252: CSSB.Template_Id=CSTB.Template_Id
3253: and CSSB.Schedule_id=b_schedule_id; --10206