DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 129: FROM PER_ASSIGNMENT_BUDGET_VALUES_F

125: p_assignment_budget_value_id NUMBER
126: )
127: IS
128: SELECT 'Y'
129: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
130: WHERE assignment_budget_value_id = p_assignment_budget_value_id
131: AND UNIT = 'FTE'
132: AND ROWNUM = 1 ;
133:

Line 154: FROM PER_ASSIGNMENT_BUDGET_VALUES_F

150: SELECT assignment_budget_value_id
151: ,effective_start_date
152: ,effective_end_date
153: ,value
154: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
155: WHERE UNIT = 'FTE'
156: AND assignment_id = g_assignment_id
157: and business_group_id = g_business_group_id;
158: