DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 103: FROM PER_ASSIGNMENT_BUDGET_VALUES_F

99: p_assignment_budget_value_id NUMBER
100: )
101: IS
102: SELECT 'Y'
103: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
104: WHERE assignment_budget_value_id = p_assignment_budget_value_id
105: AND UNIT = 'FTE'
106: AND ROWNUM = 1 ;
107:

Line 116: FROM PER_ASSIGNMENT_BUDGET_VALUES_F

112: SELECT assignment_budget_value_id
113: ,effective_start_date
114: ,effective_end_date
115: ,value
116: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
117: WHERE UNIT = 'FTE'
118: AND assignment_id = g_assignment_id
119: and business_group_id = g_business_group_id;
120: