APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_FUNDINGS

Line 1029: FROM PA_PROJECT_FUNDINGS P

1025: -- check to see if any non zero baselined funding records exists
1026:
1027: SELECT sum(nvl(allocated_amount,0))
1028: INTO l_baseline_amount
1029: FROM PA_PROJECT_FUNDINGS P
1030: WHERE P.PROJECT_ID = p_project_id
1031: AND budget_type_code = 'BASELINE';
1032:
1033: if l_baseline_amount <> 0 then

Line 1046: FROM PA_PROJECT_FUNDINGS P

1042: begin
1043:
1044: /* Modified the code for bug 3686650
1045: SELECT 'Y' into lv_return_flag
1046: FROM PA_PROJECT_FUNDINGS P
1047: WHERE P.PROJECT_ID = p_project_id
1048: AND budget_type_code = 'DRAFT';
1049: */
1050: SELECT 'Y' into lv_return_flag FROM dual

Line 1053: FROM pa_project_fundings

1049: */
1050: SELECT 'Y' into lv_return_flag FROM dual
1051: WHERE exists
1052: (SELECT project_id
1053: FROM pa_project_fundings
1054: WHERE project_id = p_project_id
1055: AND budget_type_code = 'DRAFT');
1056:
1057: return (lv_return_flag);