APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_LINES

Line 763: pa_budget_lines pbl

759:
760: select pbl.code_combination_id, pbl.budget_line_id
761: into x_budget_ccid, x_budget_line_id
762: from pa_resource_assignments pra,
763: pa_budget_lines pbl
764: where ((p_entry_level_code = 'P' and
765: pra.task_id = 0)
766: or
767: (p_entry_level_code in ('L','M','T') and

Line 1007: l_period_name pa_budget_lines.period_name%type;

1003: return Varchar2
1004: IS
1005: l_return_status varchar2(1);
1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1007: l_period_name pa_budget_lines.period_name%type;
1008: l_start_date pa_budget_lines.start_date%type;
1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1010: l_task_id pa_resource_assignments.task_id%type;
1011:

Line 1008: l_start_date pa_budget_lines.start_date%type;

1004: IS
1005: l_return_status varchar2(1);
1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1007: l_period_name pa_budget_lines.period_name%type;
1008: l_start_date pa_budget_lines.start_date%type;
1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1010: l_task_id pa_resource_assignments.task_id%type;
1011:
1012: Begin

Line 1206: select distinct start_date into l_start_date from pa_budget_lines

1202: IF P_DEBUG_MODE = 'Y' THEN
1203: pa_fck_util.debug_msg('Is_account_change_allowed: get start date');
1204: END IF;
1205:
1206: select distinct start_date into l_start_date from pa_budget_lines
1207: where budget_version_id = p_budget_version_id
1208: and resource_assignment_id = P_resource_assignment_id
1209: and period_name = l_period_name;
1210:

Line 1296: pa_budget_lines pbl

1292:
1293: Select 'N'
1294: into l_return_status
1295: from pa_resource_assignments pra,
1296: pa_budget_lines pbl
1297: where pbl.budget_version_id = p_budget_version_id
1298: and pbl.resource_assignment_id = p_resource_assignment_id
1299: and pbl.period_name = P_period_name
1300: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1384: pa_budget_lines pbl

1380:
1381: Select 'N'
1382: into l_return_status
1383: from pa_resource_assignments pra,
1384: pa_budget_lines pbl
1385: where pbl.budget_version_id = p_budget_version_id
1386: and pbl.resource_assignment_id = p_resource_assignment_id
1387: and pbl.period_name = P_period_name
1388: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1469: pa_budget_lines pbl

1465:
1466: Select 'N'
1467: into l_return_status
1468: from pa_resource_assignments pra,
1469: pa_budget_lines pbl
1470: where pbl.budget_version_id = p_budget_version_id
1471: and pbl.resource_assignment_id = p_resource_assignment_id
1472: and pbl.period_name = P_period_name
1473: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1802: FROM pa_budget_lines

1798:
1799: -- Bug 5503577 : Cursor to check if the budget has been baselined in R12.
1800: CURSOR c_check_budget_upg_status IS
1801: SELECT 'UPGRADED'
1802: FROM pa_budget_lines
1803: WHERE budget_version_id = p_budget_version_id
1804: AND bc_event_id IS NOT NULL
1805: AND rownum = 1;
1806: