APPS.PAY_P45_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 340: from per_assignment_extra_info aei

336: --
337: l_override_date date;
338: cursor csr_override_date (c_assignment_id in number) is
339: select fnd_date.canonical_to_date(aei.aei_information4)
340: from per_assignment_extra_info aei
341: where aei.assignment_id = c_assignment_id
342: and aei.information_type = 'GB_P45';
343: --
344: BEGIN

Line 1960: from per_assignment_extra_info aei

1956: --
1957: cursor csr_manual_date (c_assignment_id in number) is
1958: select 1 from dual where exists
1959: (select aei.aei_information3
1960: from per_assignment_extra_info aei
1961: where aei.assignment_id = c_assignment_id
1962: and aei.aei_information3 is not null
1963: and aei.information_type = 'GB_P45');
1964: --

Line 3972: from per_assignment_extra_info

3968: --
3969: l_manual_issue_date date;
3970: CURSOR csr_get_p45_eit_dtls(c_assignment_id NUMBER) IS
3971: select fnd_date.canonical_to_date(aei_information3)
3972: from per_assignment_extra_info
3973: where assignment_id = c_assignment_id
3974: and information_type = 'GB_P45';
3975: --
3976: BEGIN