APPS.PA_BUDGET_LINES_UTILS dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 82: pa_resource_asgn_curr_tmp ract

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';
86:

Line 89: FROM pa_resource_asgn_curr_tmp;

85: AND ra.rate_based_flag = 'Y';
86:
87: CURSOR get_rate_based_asgmts_temp_wp IS
88: SELECT resource_assignment_id
89: FROM pa_resource_asgn_curr_tmp;
90:
91: l_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type;
92: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
93: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 106: -- from the pa_resource_asgn_curr_tmp temporary table.

102: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);
103: END IF;
104:
105: -- Option #1: Process all pa_budget_lines of resource_assignment_id's read
106: -- from the pa_resource_asgn_curr_tmp temporary table.
107: -- Option #2: Process all pa_budget_lines of resource_assignment_id's read
108: -- from the IN parameter, p_resource_assignment_id_tab.
109: -- Option #3: Process all pa_budget_lines in the given budget version id.
110: