DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on HR_LOOKUPS

Line 1430: hr_lookups hr

1426: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)
1427: is
1428: select hr.meaning fin_year
1429: from per_assignment_extra_info pae,
1430: hr_lookups hr
1431: where pae.aei_information_category = 'HR_PS_ISSUE_DATE_AU'
1432: and pae.information_type = 'HR_PS_ISSUE_DATE_AU'
1433: and pae.assignment_id = c_assignment_id
1434: and pae.aei_information1 = to_char(c_fin_date,'YY')