DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 132: FROM per_assignment_extra_info paei

128: l_wage_plan_code VARCHAR2(1) := ' ';
129:
130: CURSOR c_asg_wage_plan IS
131: SELECT DISTINCT aei_information3 wage_plan
132: FROM per_assignment_extra_info paei
133: WHERE paei.assignment_id = p_assignment_id
134: AND paei.aei_information1 = p_transfer_state
135: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD';
136: