APPS.PAY_P45_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 388: from per_assignment_extra_info aei

384: --
385: l_override_date date;
386: cursor csr_override_date (c_assignment_id in number) is
387: select fnd_date.canonical_to_date(aei.aei_information4)
388: from per_assignment_extra_info aei
389: where aei.assignment_id = c_assignment_id
390: and aei.information_type = 'GB_P45';
391: --
392: BEGIN

Line 2082: from per_assignment_extra_info aei

2078: --
2079: cursor csr_manual_date (c_assignment_id in number) is
2080: select 1 from dual where exists
2081: (select aei.aei_information3
2082: from per_assignment_extra_info aei
2083: where aei.assignment_id = c_assignment_id
2084: and aei.aei_information3 is not null
2085: and aei.information_type = 'GB_P45');
2086: --

Line 4779: from per_assignment_extra_info

4775: --
4776: l_manual_issue_date date;
4777: CURSOR csr_get_p45_eit_dtls(c_assignment_id NUMBER) IS
4778: select fnd_date.canonical_to_date(aei_information3)
4779: from per_assignment_extra_info
4780: where assignment_id = c_assignment_id
4781: and information_type = 'GB_P45';
4782: --
4783: BEGIN