117: ppa.tp_percent_applied_override,
118: ppa.work_type_name,
119: ppa.transfer_price_rate, -- Added for bug 3051110
120: ppa.transfer_pr_rate_curr
121: FROM pa_project_assignments_v ppa
122: WHERE assignment_id = p_assignment_id;
123:
124: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
125: SELECT plks.meaning
4848: ppa.tp_percent_applied_override,
4849: ppa.work_type_name,
4850: ppa.transfer_price_rate, -- Added for bug 3051110
4851: ppa.transfer_pr_rate_curr
4852: FROM pa_project_assignments_v ppa
4853: WHERE assignment_id = p_assignment_id;
4854:
4855: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4856: SELECT plks.meaning
5513: ppa.tp_calc_base_code_override,
5514: ppa.tp_percent_applied_override,
5515: ppa.work_type_name,
5516: hr.name
5517: FROM pa_project_assignments_v ppa,
5518: pa_resources_denorm res,
5519: hr_all_organization_units hr
5520: WHERE ppa.assignment_id = l_assignment_id
5521: AND res.resource_id = ppa.resource_id
7317: ppa.tp_calc_base_code_override,
7318: ppa.tp_percent_applied_override,
7319: ppa.work_type_name,
7320: hr.name
7321: FROM pa_project_assignments_v ppa,
7322: pa_resources_denorm res,
7323: hr_all_organization_units hr
7324: WHERE assignment_id = l_assignment_id
7325: AND res.resource_id = ppa.resource_id