DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 121: FROM pa_project_assignments_v ppa

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

Line 4868: FROM pa_project_assignments_v ppa

4864: ppa.tp_percent_applied_override,
4865: ppa.work_type_name,
4866: ppa.transfer_price_rate, -- Added for bug 3051110
4867: ppa.transfer_pr_rate_curr
4868: FROM pa_project_assignments_v ppa
4869: WHERE assignment_id = p_assignment_id;
4870:
4871: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4872: SELECT plks.meaning

Line 5533: FROM pa_project_assignments_v ppa,

5529: ppa.tp_calc_base_code_override,
5530: ppa.tp_percent_applied_override,
5531: ppa.work_type_name,
5532: hr.name
5533: FROM pa_project_assignments_v ppa,
5534: pa_resources_denorm res,
5535: hr_all_organization_units hr
5536: WHERE ppa.assignment_id = l_assignment_id
5537: AND res.resource_id = ppa.resource_id

Line 7337: FROM pa_project_assignments_v ppa,

7333: ppa.tp_calc_base_code_override,
7334: ppa.tp_percent_applied_override,
7335: ppa.work_type_name,
7336: hr.name
7337: FROM pa_project_assignments_v ppa,
7338: pa_resources_denorm res,
7339: hr_all_organization_units hr
7340: WHERE assignment_id = l_assignment_id
7341: AND res.resource_id = ppa.resource_id