APPS.PAY_SE_ABSENCE dependencies on CAC_SR_TEMPLATES_B

Line 3250: CAC_SR_TEMPLATES_B CSTB

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
3254:

Line 3258: CAC_SR_TEMPLATES_B CSTB,

3254:
3255: CURSOR csr_get_shift_duration(b_template_id number)
3256: IS
3257: select CSRB.DURATION from
3258: CAC_SR_TEMPLATES_B CSTB,
3259: CAC_SR_TMPL_DETAILS CSTD,
3260: CAC_SR_PERIODS_B CSRB
3261: where
3262: CSTB.Template_id =CSTD.Template_Id