APPS.PA_BUDGET_LINES_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 23: FROM pa_resource_assignments

19:
20: CURSOR get_non_rate_based_asgn
21: IS
22: SELECT resource_assignment_id
23: FROM pa_resource_assignments
24: WHERE budget_version_id = p_budget_version_id
25: AND rate_based_flag = 'N';
26:
27: l_non_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 75: FROM pa_resource_assignments

71: x_return_status OUT NOCOPY VARCHAR2) is
72:
73: CURSOR get_rate_based_assignments IS
74: SELECT resource_assignment_id
75: FROM pa_resource_assignments
76: WHERE budget_version_id = p_budget_version_id
77: AND rate_based_flag = 'Y';
78:
79: CURSOR get_rate_based_asgmts_temp_fp IS

Line 81: FROM pa_resource_assignments ra,

77: AND rate_based_flag = 'Y';
78:
79: CURSOR get_rate_based_asgmts_temp_fp IS
80: SELECT ra.resource_assignment_id
81: FROM pa_resource_assignments ra,
82: pa_resource_asgn_curr_tmp ract
83: WHERE ra.budget_version_id = p_budget_version_id
84: AND ra.resource_assignment_id = ract.resource_assignment_id
85: AND ra.rate_based_flag = 'Y';

Line 154: from pa_resource_assignments

150: WHERE budget_version_id = p_budget_version_id
151: AND resource_assignment_id = p_resource_assignment_id_tab(i)
152: AND resource_assignment_id in
153: (select resource_assignment_id
154: from pa_resource_assignments
155: where rate_based_flag = 'Y'
156: and budget_version_id = p_budget_version_id
157: and resource_assignment_id = p_resource_assignment_id_tab(i));
158: END IF;