APPS.HXC_APPLICATION_SET_COMP_API dependencies on HXC_APPLICATION_SET_COMPS_V

Line 775: from HXC_APPLICATION_SET_COMPS_V

771: SELECT 'error'
772: FROM sys.dual
773: WHERE EXISTS (select a
774: from (select APPLICATION_SET_ID a, count(*) CNT
775: from HXC_APPLICATION_SET_COMPS_V
776: where TIME_RECIPIENT_ID in
777: ( select distinct time_recipient_id
778: from HXC_APPLICATION_SET_COMPS_V
779: where application_set_id = p_application_set_id

Line 778: from HXC_APPLICATION_SET_COMPS_V

774: from (select APPLICATION_SET_ID a, count(*) CNT
775: from HXC_APPLICATION_SET_COMPS_V
776: where TIME_RECIPIENT_ID in
777: ( select distinct time_recipient_id
778: from HXC_APPLICATION_SET_COMPS_V
779: where application_set_id = p_application_set_id
780: )
781: and application_set_id <> p_application_set_id
782: group by application_set_id

Line 785: from HXC_APPLICATION_SET_COMPS_V

781: and application_set_id <> p_application_set_id
782: group by application_set_id
783: )
784: where CNT = ( select count(distinct time_recipient_id)
785: from HXC_APPLICATION_SET_COMPS_V
786: where application_set_id = p_application_set_id
787: )
788: and a not in (
789: select APPLICATION_SET_ID a

Line 790: from HXC_APPLICATION_SET_COMPS_V

786: where application_set_id = p_application_set_id
787: )
788: and a not in (
789: select APPLICATION_SET_ID a
790: from HXC_APPLICATION_SET_COMPS_V
791: where TIME_RECIPIENT_ID not in
792: ( select distinct time_recipient_id
793: from HXC_APPLICATION_SET_COMPS_V
794: where application_set_id = p_application_set_id

Line 793: from HXC_APPLICATION_SET_COMPS_V

789: select APPLICATION_SET_ID a
790: from HXC_APPLICATION_SET_COMPS_V
791: where TIME_RECIPIENT_ID not in
792: ( select distinct time_recipient_id
793: from HXC_APPLICATION_SET_COMPS_V
794: where application_set_id = p_application_set_id
795: )
796: and application_set_id <> p_application_set_id
797: ));