DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 24: -- In c_history_id join on PER_PEOPLE_EXTRA_INFO is required to skip the history records

20: -- This cursor gets the latest date on which the given Extra information Type record
21: -- is inserted or updated on or before the given date
22: -- and then gets the the record with highest history id on that date.
23:
24: -- In c_history_id join on PER_PEOPLE_EXTRA_INFO is required to skip the history records
25: -- on the extra information records that are deleted.
26: cursor c_history_id is
27: select max(gph1.pa_history_id) pa_history_id
28: from ghr_pa_history gph1,

Line 29: PER_PEOPLE_EXTRA_INFO pei1

25: -- on the extra information records that are deleted.
26: cursor c_history_id is
27: select max(gph1.pa_history_id) pa_history_id
28: from ghr_pa_history gph1,
29: PER_PEOPLE_EXTRA_INFO pei1
30: where gph1.table_name = 'PER_PEOPLE_EXTRA_INFO'
31: and pei1.person_id = p_person_id
32: and pei1.information_type = p_information_type
33: and gph1.information1 = to_char(pei1.person_extra_info_id)

Line 30: where gph1.table_name = 'PER_PEOPLE_EXTRA_INFO'

26: cursor c_history_id is
27: select max(gph1.pa_history_id) pa_history_id
28: from ghr_pa_history gph1,
29: PER_PEOPLE_EXTRA_INFO pei1
30: where gph1.table_name = 'PER_PEOPLE_EXTRA_INFO'
31: and pei1.person_id = p_person_id
32: and pei1.information_type = p_information_type
33: and gph1.information1 = to_char(pei1.person_extra_info_id)
34: and gph1.effective_date = ( select max(gph2.effective_date)maxdate

Line 36: where gph2.table_name = 'PER_PEOPLE_EXTRA_INFO'

32: and pei1.information_type = p_information_type
33: and gph1.information1 = to_char(pei1.person_extra_info_id)
34: and gph1.effective_date = ( select max(gph2.effective_date)maxdate
35: from ghr_pa_history gph2
36: where gph2.table_name = 'PER_PEOPLE_EXTRA_INFO'
37: and gph2.effective_date <= p_effective_date
38: and gph2.information1 = to_char(pei1.person_extra_info_id)) ;
39:
40: