63: --
64: -- BEGIN TCA_UNMERGE CHANGES
65: cursor c_person is
66: select *
67: from per_all_people_f
68: where person_id = p_person_id
69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;
69: and p_effective_date
70: between effective_start_date
71: and effective_end_date;
72: --
73: l_person per_all_people_f%rowtype;
74: --
75: -- TCA_UNMERGE
76: begin
77: --
616: --
617: -- BEGIN TCA_UNMERGE CHANGES
618: cursor c_person is
619: select *
620: from per_all_people_f
621: where person_id = p_person_id
622: and p_effective_date
623: between effective_start_date
624: and effective_end_date;
622: and p_effective_date
623: between effective_start_date
624: and effective_end_date;
625: --
626: l_person per_all_people_f%rowtype;
627: --
628: -- TCA_UNMERGE
629: begin
630: --
1023: --
1024: -- BEGIN TCA_UNMERGE CHANGES
1025: cursor c_person is
1026: select *
1027: from per_all_people_f
1028: where person_id = p_person_id
1029: and p_effective_date
1030: between effective_start_date
1031: and effective_end_date;
1029: and p_effective_date
1030: between effective_start_date
1031: and effective_end_date;
1032: --
1033: l_person per_all_people_f%rowtype;
1034: --
1035: -- TCA_UNMERGE
1036: --
1037: begin
1555: --
1556: -- BEGIN TCA_UNMERGE CHANGES
1557: cursor c_person is
1558: select *
1559: from per_all_people_f
1560: where person_id = p_person_id
1561: and p_effective_date
1562: between effective_start_date
1563: and effective_end_date;
1561: and p_effective_date
1562: between effective_start_date
1563: and effective_end_date;
1564: --
1565: l_person per_all_people_f%rowtype;
1566: --
1567: -- TCA_UNMERGE
1568: --
1569: begin