DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_PAY_PROPOSALS

Line 1742: from per_pay_proposals

1738:
1739: Cursor C_prop_sal is
1740: Select nvl(proposed_salary_n,0) proposed_salary,
1741: change_date
1742: from per_pay_proposals
1743: where assignment_id = l_assignment_id
1744: and change_date =
1745: (select max(change_date) from
1746: per_pay_proposals where

Line 1746: per_pay_proposals where

1742: from per_pay_proposals
1743: where assignment_id = l_assignment_id
1744: and change_date =
1745: (select max(change_date) from
1746: per_pay_proposals where
1747: assignment_id = l_assignment_id
1748: and approved = 'Y');
1749:
1750: Cursor C_step is