DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on GL_SETS_OF_BOOKS

Line 64: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

60: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
61:
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;

Line 65: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

61:
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;

Line 243: FROM gl_sets_of_books gsb

239: 'COST',ppfo.cost_time_phased_code,
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

Line 1528: l_period_set_name gl_sets_of_books.period_set_name%type;

1524:
1525: /*
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:

Line 1529: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;

1525: /*
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:

Line 1543: FROM gl_sets_of_books gsb

1539: 'COST',ppfo.cost_time_phased_code,
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