[Home] [Help]
974: -- Bug 2933498 starts here.
975: -- Modified the cursor csr_invalid_non_prim.
976: cursor csr_invalid_non_prim is
977: select null
978: from sys.dual
979: where exists(select null
980: from per_addresses pa
981: where ((pa.date_from < p_date_from
982: and nvl(pa.date_to, hr_api.g_eot) >=
1001: -- Bug 2933498 ends here.
1002: --
1003: cursor csr_check_other_addresses is
1004: select null
1005: from sys.dual
1006: where exists(select null
1007: from per_addresses pa
1008: where (pa.person_id = p_person_id OR
1009: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
3993: and pa.primary_flag = 'N';
3994: --
3995: cursor csr_no_del_contig_add is
3996: select null
3997: from sys.dual
3998: where exists(select null
3999: from per_addresses pa2
4000: where pa2.date_from > l_date
4001: and pa2.person_id = per_add_shd.g_old_rec.person_id