DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 163: FROM per_assignment_extra_info paei

159: l_wage_plan_code VARCHAR2(1) := ' ';
160:
161: CURSOR c_asg_wage_plan IS
162: SELECT DISTINCT aei_information3 wage_plan
163: FROM per_assignment_extra_info paei
164: WHERE paei.assignment_id = p_assignment_id
165: AND paei.aei_information1 = p_transfer_state
166: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD';
167: