DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_IMPLEMENTATIONS_ALL

Line 65: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

61: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
62:
63: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
64: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
65: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
66: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
67: l_period_name gl_periods.period_name%TYPE;
68: l_period_start_date DATE;
69: l_period_end_date DATE;

Line 208: ,pa_implementations_all pia

204: 'COST',ppfo.cost_time_phased_code,
205: 'REVENUE',ppfo.revenue_time_phased_code,
206: ppfo.all_time_phased_code) time_phase_code
207: FROM gl_sets_of_books gsb
208: ,pa_implementations_all pia
209: ,pa_projects_all ppa
210: ,pa_budget_versions pbv
211: ,pa_proj_fp_options ppfo
212: WHERE ppa.project_id = pbv.project_id

Line 1317: l_pa_period_type pa_implementations_all.pa_period_type%type;

1313: FUNCTION GET_PERIOD_START_DATE(P_PERIOD_NAME IN VARCHAR2, P_BUDGET_VERSION_ID IN NUMBER) RETURN DATE IS
1314:
1315: l_period_set_name gl_sets_of_books.period_set_name%type;
1316: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;
1317: l_pa_period_type pa_implementations_all.pa_period_type%type;
1318: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;
1319:
1320:
1321: cursor c_period_data IS

Line 1331: ,pa_implementations_all pia

1327: 'REVENUE',ppfo.revenue_time_phased_code,
1328: ppfo.all_time_phased_code) time_phase_code
1329: ,glp.start_date period_start_date,glp.end_date period_end_date
1330: FROM gl_sets_of_books gsb
1331: ,pa_implementations_all pia
1332: ,pa_projects_all ppa
1333: ,pa_budget_versions pbv
1334: ,pa_proj_fp_options ppfo
1335: ,gl_periods glp