DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on PER_PAY_PROPOSALS

Line 1378: ,PER_PAY_PROPOSALS pay

1374: ,asg.organization_id as p_organization_id
1375: ,asg.business_group_id as p_business_group_id
1376: ,pay.change_date as p_effective_date
1377: FROM PER_ALL_ASSIGNMENTS_F asg
1378: ,PER_PAY_PROPOSALS pay
1379: WHERE asg.assignment_id = p_assignment_id
1380: and pay.assignment_id = p_assignment_id
1381: and asg.effective_end_date = ( SELECT max (effective_end_date)
1382: FROM per_all_assignments_f