APPS.PAY_SE_GENERAL dependencies on CAC_SR_SCHEDULES_B

Line 434: CAC_SR_SCHEDULES_B CSSB

430: IS
431: SELECT CSSB.SCHEDULE_ID
432: from
433: CAC_SR_SCHDL_OBJECTS CSSO,
434: CAC_SR_SCHEDULES_B CSSB
435: where
436: CSSO.OBJECT_TYPE = b_object_type
437: AND CSSO.OBJECT_ID = b_object_id
438: AND CSSO.START_DATE_ACTIVE <= b_end_dt

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

447: AND b_schdl_cat IS NULL
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