DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on GL_SETS_OF_BOOKS

Line 63: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

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

Line 64: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

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

Line 207: FROM gl_sets_of_books gsb

203: ,decode(pbv.version_type,
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

Line 1315: l_period_set_name gl_sets_of_books.period_set_name%type;

1311:
1312: /*
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:

Line 1316: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;

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

Line 1330: FROM gl_sets_of_books gsb

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