APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BC_BALANCES

Line 7601: FROM pa_bc_balances

7597:
7598: IF p_time_phase_type_code in ('P','G') and l_project_start_date is NULL then
7599: SELECT MIN ( start_date )
7600: INTO l_project_start_date
7601: FROM pa_bc_balances
7602: WHERE budget_version_id = p_budget_version_id
7603: AND project_id = p_project_id
7604: AND balance_type = 'BGT';
7605:

Line 7611: FROM pa_bc_balances

7607:
7608: IF ( l_project_end_date IS NULL ) THEN
7609: SELECT MAX ( end_date )
7610: INTO l_bal_end_date
7611: FROM pa_bc_balances
7612: WHERE budget_version_id = p_budget_version_id
7613: AND project_id = p_project_id
7614: AND balance_type = 'BGT';
7615:

Line 7683: FROM pa_bc_balances

7679: g_error_stage := 'Time Phase R';
7680: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'Time Phase = R');
7681: SELECT TRUNC ( MAX ( start_date ))
7682: INTO l_dr_period_start_date
7683: FROM pa_bc_balances
7684: WHERE project_id = p_project_id
7685: AND budget_version_id = p_budget_version_id
7686: AND balance_type = 'BGT'
7687: AND start_date <= p_expenditure_item_date;

Line 7691: FROM pa_bc_balances

7687: AND start_date <= p_expenditure_item_date;
7688:
7689: SELECT TRUNC ( MIN ( end_date ))
7690: INTO l_dr_period_end_date
7691: FROM pa_bc_balances
7692: WHERE project_id = p_project_id
7693: AND budget_version_id = p_budget_version_id
7694: AND balance_type = 'BGT'
7695: AND end_date >= p_expenditure_item_date;

Line 7737: FROM pa_bc_balances

7733: EXCEPTION
7734: WHEN NO_DATA_FOUND THEN
7735: SELECT TRUNC ( MIN ( start_date ))
7736: INTO l_gs_start_date
7737: FROM pa_bc_balances
7738: WHERE project_id = p_project_id
7739: AND budget_version_id = p_budget_version_id
7740: AND balance_type = 'BGT';
7741: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_start_date is = '||l_gs_start_date);

Line 7759: FROM pa_bc_balances

7755: EXCEPTION
7756: WHEN NO_DATA_FOUND THEN
7757: SELECT TRUNC ( MIN ( start_date ))
7758: INTO l_gs_start_date
7759: FROM pa_bc_balances
7760: WHERE project_id = p_project_id
7761: AND budget_version_id = p_budget_version_id
7762: AND balance_type = 'BGT';
7763: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_start_date is = '||l_gs_start_date);

Line 7770: FROM pa_bc_balances

7766: g_error_stage := 'PJTD-R';
7767: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-R');
7768: SELECT TRUNC ( MIN ( start_date ))
7769: INTO l_gs_start_date
7770: FROM pa_bc_balances
7771: WHERE project_id = p_project_id
7772: AND budget_version_id = p_budget_version_id
7773: AND balance_type = 'BGT';
7774: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_start_date is = '||l_gs_start_date);

Line 7799: FROM pa_bc_balances

7795: EXCEPTION
7796: WHEN NO_DATA_FOUND THEN
7797: SELECT TRUNC ( MAX ( end_date ))
7798: INTO l_gs_end_date
7799: FROM pa_bc_balances
7800: WHERE project_id = p_project_id
7801: AND budget_version_id = p_budget_version_id
7802: AND balance_type = 'BGT';
7803: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_end_date is = '||l_gs_end_date);

Line 7826: FROM pa_bc_balances

7822: EXCEPTION
7823: WHEN NO_DATA_FOUND THEN
7824: SELECT TRUNC ( MAX ( end_date ))
7825: INTO l_gs_end_date
7826: FROM pa_bc_balances
7827: WHERE project_id = p_project_id
7828: AND budget_version_id = p_budget_version_id
7829: AND balance_type = 'BGT';
7830: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_end_date is = '||l_gs_end_date);

Line 8497: -- from PA_BC_PACKETS to PA_BC_BALANCES and PA_BC_COMMITMENTS

8493: End if;
8494:
8495: -----------------------------------------------------------------------------------+
8496: -- Invoke the Sweeper process to sweep all the encumbrance etries
8497: -- from PA_BC_PACKETS to PA_BC_BALANCES and PA_BC_COMMITMENTS
8498: -----------------------------------------------------------------------------------+
8499: PA_Sweeper.Update_Act_Enc_Balance (
8500: X_Return_Status => l_Return_Status,
8501: X_Error_Message_Code => l_Msg_Data