APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_LINES

Line 914: pa_budget_lines pbl

910:
911: select pbl.code_combination_id, pbl.budget_line_id
912: into x_budget_ccid, x_budget_line_id
913: from pa_resource_assignments pra,
914: pa_budget_lines pbl
915: where ((p_entry_level_code = 'P' and
916: pra.task_id = 0)
917: or
918: (p_entry_level_code in ('L','M','T') and

Line 1158: l_period_name pa_budget_lines.period_name%type;

1154: return Varchar2
1155: IS
1156: l_return_status varchar2(1);
1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1158: l_period_name pa_budget_lines.period_name%type;
1159: l_start_date pa_budget_lines.start_date%type;
1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1161: l_task_id pa_resource_assignments.task_id%type;
1162:

Line 1159: l_start_date pa_budget_lines.start_date%type;

1155: IS
1156: l_return_status varchar2(1);
1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1158: l_period_name pa_budget_lines.period_name%type;
1159: l_start_date pa_budget_lines.start_date%type;
1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1161: l_task_id pa_resource_assignments.task_id%type;
1162:
1163: Begin

Line 1357: select distinct start_date into l_start_date from pa_budget_lines

1353: IF P_DEBUG_MODE = 'Y' THEN
1354: pa_fck_util.debug_msg('Is_account_change_allowed: get start date');
1355: END IF;
1356:
1357: select distinct start_date into l_start_date from pa_budget_lines
1358: where budget_version_id = p_budget_version_id
1359: and resource_assignment_id = P_resource_assignment_id
1360: and period_name = l_period_name;
1361:

Line 1447: pa_budget_lines pbl

1443:
1444: Select 'N'
1445: into l_return_status
1446: from pa_resource_assignments pra,
1447: pa_budget_lines pbl
1448: where pbl.budget_version_id = p_budget_version_id
1449: and pbl.resource_assignment_id = p_resource_assignment_id
1450: and pbl.period_name = P_period_name
1451: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1535: pa_budget_lines pbl

1531:
1532: Select 'N'
1533: into l_return_status
1534: from pa_resource_assignments pra,
1535: pa_budget_lines pbl
1536: where pbl.budget_version_id = p_budget_version_id
1537: and pbl.resource_assignment_id = p_resource_assignment_id
1538: and pbl.period_name = P_period_name
1539: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1620: pa_budget_lines pbl

1616:
1617: Select 'N'
1618: into l_return_status
1619: from pa_resource_assignments pra,
1620: pa_budget_lines pbl
1621: where pbl.budget_version_id = p_budget_version_id
1622: and pbl.resource_assignment_id = p_resource_assignment_id
1623: and pbl.period_name = P_period_name
1624: and pra.resource_assignment_id = pbl.resource_assignment_id

Line 1953: FROM pa_budget_lines

1949:
1950: -- Bug 5503577 : Cursor to check if the budget has been baselined in R12.
1951: CURSOR c_check_budget_upg_status IS
1952: SELECT 'UPGRADED'
1953: FROM pa_budget_lines
1954: WHERE budget_version_id = p_budget_version_id
1955: AND bc_event_id IS NOT NULL
1956: AND rownum = 1;
1957: