APPS.PER_ADDRESSES_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 1525: from per_person_type_usages_f p, per_person_types t

1521: -- start changes for bug#10067018
1522: -- start changes for bug13562523
1523: cursor check_emp_cwk_person_type1(date1 date) is
1524: select 'Y'
1525: from per_person_type_usages_f p, per_person_types t
1526: where p.person_id = p_person_id
1527: and p.person_type_id = t.person_type_id
1528: and t.system_person_type in ('EMP','CWK')
1529: and nvl(date1,to_date('31-12-4712','DD-MM-YYYY')) between effective_start_date and effective_end_date-1;

Line 1533: from per_person_type_usages_f p, per_person_types t

1529: and nvl(date1,to_date('31-12-4712','DD-MM-YYYY')) between effective_start_date and effective_end_date-1;
1530:
1531: cursor check_emp_cwk_person_type2(date1 date) is
1532: select effective_start_date, effective_end_date
1533: from per_person_type_usages_f p, per_person_types t
1534: where p.person_id = p_person_id
1535: and p.person_type_id = t.person_type_id
1536: and t.system_person_type in ('EMP','CWK')
1537: and effective_start_date > nvl(date1,to_date('31-12-4712','DD-MM-YYYY')) ;