APPS.PAY_SE_GENERAL dependencies on CAC_SR_TEMPLATES_B

Line 452: CAC_SR_TEMPLATES_B CSTB

448: ));
449: CURSOR csr_get_template_details(b_schedule_id number)
450: IS
451: select CSTB.Template_Id,CSTB.TEMPLATE_LENGTH_DAYS from CAC_SR_SCHEDULES_B CSSB,
452: CAC_SR_TEMPLATES_B CSTB
453: where
454: CSSB.Template_Id=CSTB.Template_Id
455: and CSSB.Schedule_id=b_schedule_id; --10206
456:

Line 460: CAC_SR_TEMPLATES_B CSTB,

456:
457: CURSOR csr_get_shift_duration(b_template_id number)
458: IS
459: select CSRB.DURATION from
460: CAC_SR_TEMPLATES_B CSTB,
461: CAC_SR_TMPL_DETAILS CSTD,
462: CAC_SR_PERIODS_B CSRB
463: where
464: CSTB.Template_id =CSTD.Template_Id