DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_IMPLEMENTATIONS_ALL

Line 66: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

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

Line 244: ,pa_implementations_all pia

240: 'REVENUE',ppfo.revenue_time_phased_code,
241: ppfo.all_time_phased_code) time_phase_code
242: ,pbv.etc_start_date
243: FROM gl_sets_of_books gsb
244: ,pa_implementations_all pia
245: ,pa_projects_all ppa
246: ,pa_budget_versions pbv
247: ,pa_proj_fp_options ppfo
248: WHERE ppa.project_id = pbv.project_id

Line 1530: l_pa_period_type pa_implementations_all.pa_period_type%type;

1526: FUNCTION GET_PERIOD_START_DATE(P_PERIOD_NAME IN VARCHAR2, P_BUDGET_VERSION_ID IN NUMBER) RETURN DATE IS
1527:
1528: l_period_set_name gl_sets_of_books.period_set_name%type;
1529: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;
1530: l_pa_period_type pa_implementations_all.pa_period_type%type;
1531: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;
1532:
1533:
1534: cursor c_period_data IS

Line 1544: ,pa_implementations_all pia

1540: 'REVENUE',ppfo.revenue_time_phased_code,
1541: ppfo.all_time_phased_code) time_phase_code
1542: ,glp.start_date period_start_date,glp.end_date period_end_date
1543: FROM gl_sets_of_books gsb
1544: ,pa_implementations_all pia
1545: ,pa_projects_all ppa
1546: ,pa_budget_versions pbv
1547: ,pa_proj_fp_options ppfo
1548: ,gl_periods glp