APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_FUNDINGS

Line 1036: FROM PA_PROJECT_FUNDINGS P

1032: -- check to see if any non zero baselined funding records exists
1033:
1034: SELECT sum(nvl(allocated_amount,0))
1035: INTO l_baseline_amount
1036: FROM PA_PROJECT_FUNDINGS P
1037: WHERE P.PROJECT_ID = p_project_id
1038: AND budget_type_code = 'BASELINE';
1039:
1040: if l_baseline_amount <> 0 then

Line 1053: FROM PA_PROJECT_FUNDINGS P

1049: begin
1050:
1051: /* Modified the code for bug 3686650
1052: SELECT 'Y' into lv_return_flag
1053: FROM PA_PROJECT_FUNDINGS P
1054: WHERE P.PROJECT_ID = p_project_id
1055: AND budget_type_code = 'DRAFT';
1056: */
1057: SELECT 'Y' into lv_return_flag FROM dual

Line 1060: FROM pa_project_fundings

1056: */
1057: SELECT 'Y' into lv_return_flag FROM dual
1058: WHERE exists
1059: (SELECT project_id
1060: FROM pa_project_fundings
1061: WHERE project_id = p_project_id
1062: AND budget_type_code = 'DRAFT');
1063:
1064: return (lv_return_flag);