45: from ast_lookups
46: where lookup_type = lkp_type
47: and lookup_code = lkp_code;
48:
49: l_Profile:=NVL(fnd_profile.value('AST_MLIST_ALL_CAMPAIGNS'),'N');
50: l_Access:= NVL(fnd_profile.value('AS_CUST_ACCESS'), 'F');
51:
52: /* 'Y' - List All Campaign, 'N' - List only Assigned Campaign using Campaign Assignment */
53: if ( l_profile = 'Y' ) then
46: where lookup_type = lkp_type
47: and lookup_code = lkp_code;
48:
49: l_Profile:=NVL(fnd_profile.value('AST_MLIST_ALL_CAMPAIGNS'),'N');
50: l_Access:= NVL(fnd_profile.value('AS_CUST_ACCESS'), 'F');
51:
52: /* 'Y' - List All Campaign, 'N' - List only Assigned Campaign using Campaign Assignment */
53: if ( l_profile = 'Y' ) then
54: