APPS.PSB_POSITION_CONTROL_PVT dependencies on PQH_PSB_BUDGET_VERSIONS

Line 9409: from pqh_psb_budget_versions

9405:
9406: cursor c_brversion is
9407: select version_number, budget_version_id, object_version_number, date_from, date_to,
9408: budget_unit1_value, budget_unit2_value, budget_unit3_value
9409: from pqh_psb_budget_versions
9410: where budget_id = p_hr_budget_id
9411: and version_number =
9412: (select max(version_number) from pqh_psb_budget_versions
9413: where budget_id = p_hr_budget_id);

Line 9412: (select max(version_number) from pqh_psb_budget_versions

9408: budget_unit1_value, budget_unit2_value, budget_unit3_value
9409: from pqh_psb_budget_versions
9410: where budget_id = p_hr_budget_id
9411: and version_number =
9412: (select max(version_number) from pqh_psb_budget_versions
9413: where budget_id = p_hr_budget_id);
9414:
9415: cursor c_bpversion is
9416: select version_number, budget_version_id, object_version_number

Line 9417: from pqh_psb_budget_versions

9413: where budget_id = p_hr_budget_id);
9414:
9415: cursor c_bpversion is
9416: select version_number, budget_version_id, object_version_number
9417: from pqh_psb_budget_versions
9418: where budget_id = p_hr_budget_id
9419: and date_from = p_start_date
9420: and date_to = p_end_date;
9421:

Line 10813: l_ver_object_version_number pqh_psb_budget_versions.object_version_number%TYPE;

10809: l_job_id NUMBER;
10810: l_hr_employee_id NUMBER;
10811: l_position_name VARCHAR2(240);
10812: l_effective_start_date DATE;
10813: l_ver_object_version_number pqh_psb_budget_versions.object_version_number%TYPE;
10814: l_version_number NUMBER;
10815: l_start_date DATE;
10816: l_end_date DATE;
10817: l_payroll_id NUMBER;

Line 10930: from pqh_psb_budget_versions

10926: and c.data_extract_id = p_system_data_extract_id;
10927:
10928: cursor c_version_details is
10929: select *
10930: from pqh_psb_budget_versions
10931: where budget_version_id = p_pqh_budget_version_id;
10932:
10933: /*For Bug No : 2434152 Start*/
10934: cursor c_sob_id is