DBA Data[Home] [Help]

APPS.FPA_VALIDATION_PROCESS_PVT dependencies on DUAL

Line 73: into l_cost_plan_type, l_benefit_plan_type from dual;

69:
70: select
71: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST'),
72: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
73: into l_cost_plan_type, l_benefit_plan_type from dual;
74: if(l_cost_plan_type is null or l_benefit_plan_type is null) then
75: return;
76: end if;
77:

Line 1040: INTO L_COST_PLAN_TYPE, L_BENEFIT_PLAN_TYPE FROM DUAL;

1036:
1037: SELECT
1038: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST'),
1039: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
1040: INTO L_COST_PLAN_TYPE, L_BENEFIT_PLAN_TYPE FROM DUAL;
1041:
1042: if(l_cost_plan_type is null or l_benefit_plan_type is null) then
1043: return;
1044: end if;