DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_PERSON_DLVRY_METHODS

Line 1101: FROM PER_PERSON_DLVRY_METHODS

1097: , ATTRIBUTE17
1098: , ATTRIBUTE18
1099: , ATTRIBUTE19
1100: , ATTRIBUTE20
1101: FROM PER_PERSON_DLVRY_METHODS
1102: where person_id = p_person_id;
1103:
1104: -- cursor to fetch the assignment extra information
1105: CURSOR csr_ass_extra_info_record(p_person_id number,p_business_group_id number,p_eff_date date) is

Line 1638: ,per_person_dlvry_methods ppdm

1634:
1635: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1636: from per_people_f ppf
1637: ,per_person_types ppt
1638: ,per_person_dlvry_methods ppdm
1639: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1640: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1641: and ppdm.person_id = ppf.person_id
1642: and ppdm.delivery_method_id = p_srch_criteria(i).p_delivery_method_id;