APPS.MSD_COMMON_UTILITIES_LB dependencies on MSC_ASL_AUTH_DETAILS

Line 642: /* This function populates MSC_ASL_AUTH_DETAILS with start date and end date */

638:
639:
640: END get_liability_url ;
641:
642: /* This function populates MSC_ASL_AUTH_DETAILS with start date and end date */
643:
644: procedure liability_preprocessor(p_plan_id IN NUMBER )
645:
646: IS

Line 660: msc_asl_auth_details

656: cutoff_days,
657: INCLUDE_LIABILITY_AGREEMENT,
658: ASL_LIABILITY_AGREEMENT_BASIS
659: from
660: msc_asl_auth_details
661: where
662: plan_id = -1
663: /* and INCLUDE_LIABILITY_AGREEMENT = 1 This filter will remove any disabled agreement */
664: order

Line 716: UPDATE msc_asl_auth_details

712: x_end_days := 0 ;
713: end if ;
714:
715:
716: UPDATE msc_asl_auth_details
717: set start_days = x_end_days ,
718: end_days = x_end_days + cutoff_days
719: where
720: PLAN_ID = -1 and