APPS.AST_UWQ_LEADS_ENUMS_PVT dependencies on FND_PROFILE

Line 56: l_prior_days := NVL(fnd_profile.value('AST_DEFAULT_PRIOR_DAYS'), '30');

52:
53: /* label, view, and where for main node taken from enum table anyway */
54:
55: l_node_counter := 0;
56: l_prior_days := NVL(fnd_profile.value('AST_DEFAULT_PRIOR_DAYS'), '30');
57:
58: SAVEPOINT start_lead_enumeration;
59:
60: -- ***************************************

Line 465: 'AND (sysdate - last_update_date) > NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';

461:
462:
463: l_ld_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
464: 'STATUS_CODE in (Select status_code from as_statuses_b where opp_open_status_flag=''Y'' and lead_flag = ''Y'' and enabled_flag = ''Y'') '||
465: 'AND (sysdate - last_update_date) > NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';
466:
467: l_ld_list(l_node_counter).NODE_TYPE := 0;
468: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
469: l_ld_list(l_node_counter).NODE_DEPTH := 2;

Line 524: l_prior_days := NVL(fnd_profile.value('AST_DEFAULT_PRIOR_DAYS'), '30');

520:
521: /* label, view, and where for main node taken from enum table anyway */
522:
523: l_node_counter := 0;
524: l_prior_days := NVL(fnd_profile.value('AST_DEFAULT_PRIOR_DAYS'), '30');
525: SAVEPOINT start_lead_enumeration;
526:
527: -- ***************************************
528: -- swkhanna 9/3

Line 901: 'AND (sysdate - last_update_date) > NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';

897: l_ld_list(l_node_counter).MEDIA_TYPE_ID := '';
898:
899: l_ld_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
900: 'STATUS_CODE in (Select status_code from as_statuses_b where opp_open_status_flag=''Y'' and lead_flag = ''Y'' and enabled_flag = ''Y'') '||
901: 'AND (sysdate - last_update_date) > NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';
902:
903: l_ld_list(l_node_counter).NODE_TYPE := 0;
904: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
905: l_ld_list(l_node_counter).NODE_DEPTH := 2;