DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on HR_LOOKUPS

Line 1054: hr_lookups hr

1050: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)
1051: is
1052: select hr.meaning fin_year
1053: from per_assignment_extra_info pae,
1054: hr_lookups hr
1055: where pae.aei_information_category = 'HR_PS_ISSUE_DATE_AU'
1056: and pae.information_type = 'HR_PS_ISSUE_DATE_AU'
1057: and pae.assignment_id = c_assignment_id
1058: and pae.aei_information1 = to_char(c_fin_date,'YY')