APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BC_BALANCES

Line 7254: FROM pa_bc_balances

7250:
7251: IF p_time_phase_type_code in ('P','G') and l_project_start_date is NULL then
7252: SELECT MIN ( start_date )
7253: INTO l_project_start_date
7254: FROM pa_bc_balances
7255: WHERE budget_version_id = p_budget_version_id
7256: AND project_id = p_project_id
7257: AND balance_type = 'BGT';
7258:

Line 7264: FROM pa_bc_balances

7260:
7261: IF ( l_project_end_date IS NULL ) THEN
7262: SELECT MAX ( end_date )
7263: INTO l_bal_end_date
7264: FROM pa_bc_balances
7265: WHERE budget_version_id = p_budget_version_id
7266: AND project_id = p_project_id
7267: AND balance_type = 'BGT';
7268:

Line 7327: FROM pa_bc_balances

7323: g_error_stage := 'Time Phase R';
7324: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'Time Phase = R');
7325: SELECT TRUNC ( MAX ( start_date ))
7326: INTO l_dr_period_start_date
7327: FROM pa_bc_balances
7328: WHERE project_id = p_project_id
7329: AND budget_version_id = p_budget_version_id
7330: AND balance_type = 'BGT'
7331: AND start_date <= p_expenditure_item_date;

Line 7335: FROM pa_bc_balances

7331: AND start_date <= p_expenditure_item_date;
7332:
7333: SELECT TRUNC ( MIN ( end_date ))
7334: INTO l_dr_period_end_date
7335: FROM pa_bc_balances
7336: WHERE project_id = p_project_id
7337: AND budget_version_id = p_budget_version_id
7338: AND balance_type = 'BGT'
7339: AND end_date >= p_expenditure_item_date;

Line 7376: FROM pa_bc_balances

7372: EXCEPTION
7373: WHEN NO_DATA_FOUND THEN
7374: SELECT TRUNC ( MIN ( start_date ))
7375: INTO l_gs_start_date
7376: FROM pa_bc_balances
7377: WHERE project_id = p_project_id
7378: AND budget_version_id = p_budget_version_id
7379: AND balance_type = 'BGT';
7380: END;

Line 7396: FROM pa_bc_balances

7392: EXCEPTION
7393: WHEN NO_DATA_FOUND THEN
7394: SELECT TRUNC ( MIN ( start_date ))
7395: INTO l_gs_start_date
7396: FROM pa_bc_balances
7397: WHERE project_id = p_project_id
7398: AND budget_version_id = p_budget_version_id
7399: AND balance_type = 'BGT';
7400: END;

Line 7406: FROM pa_bc_balances

7402: g_error_stage := 'PJTD-R';
7403: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-R');
7404: SELECT TRUNC ( MIN ( start_date ))
7405: INTO l_gs_start_date
7406: FROM pa_bc_balances
7407: WHERE project_id = p_project_id
7408: AND budget_version_id = p_budget_version_id
7409: AND balance_type = 'BGT';
7410:

Line 7434: FROM pa_bc_balances

7430: EXCEPTION
7431: WHEN NO_DATA_FOUND THEN
7432: SELECT TRUNC ( MAX ( end_date ))
7433: INTO l_gs_end_date
7434: FROM pa_bc_balances
7435: WHERE project_id = p_project_id
7436: AND budget_version_id = p_budget_version_id
7437: AND balance_type = 'BGT';
7438: END;

Line 7459: FROM pa_bc_balances

7455: EXCEPTION
7456: WHEN NO_DATA_FOUND THEN
7457: SELECT TRUNC ( MAX ( end_date ))
7458: INTO l_gs_end_date
7459: FROM pa_bc_balances
7460: WHERE project_id = p_project_id
7461: AND budget_version_id = p_budget_version_id
7462: AND balance_type = 'BGT';
7463: END;

Line 8123: -- from PA_BC_PACKETS to PA_BC_BALANCES and PA_BC_COMMITMENTS

8119: End if;
8120:
8121: -----------------------------------------------------------------------------------+
8122: -- Invoke the Sweeper process to sweep all the encumbrance etries
8123: -- from PA_BC_PACKETS to PA_BC_BALANCES and PA_BC_COMMITMENTS
8124: -----------------------------------------------------------------------------------+
8125: PA_Sweeper.Update_Act_Enc_Balance (
8126: X_Return_Status => l_Return_Status,
8127: X_Error_Message_Code => l_Msg_Data