APPS.BEN_WHATIF_ELIG dependencies on PER_PERSON_TYPE_USAGES_F

Line 2544: per_per_usg_rec per_person_type_usages_f%rowtype;

2540: ,p_business_group_id in number
2541: ,p_effective_date in date
2542: ) is
2543: --
2544: per_per_usg_rec per_person_type_usages_f%rowtype;
2545: --
2546: cursor c_per_usg is
2547: select * from per_person_type_usages_f
2548: where person_id = p_person_id and

Line 2547: select * from per_person_type_usages_f

2543: --
2544: per_per_usg_rec per_person_type_usages_f%rowtype;
2545: --
2546: cursor c_per_usg is
2547: select * from per_person_type_usages_f
2548: where person_id = p_person_id and
2549: p_effective_date between nvl(effective_start_date, p_effective_date)
2550: and nvl(effective_end_date, p_effective_date);
2551: --

Line 2556: per_person_type_usages_f ptu

2552: cursor c_get_per_typ is
2553: select pt.system_person_type, ptu.*
2554: from per_all_people_f per,
2555: per_person_types pt,
2556: per_person_type_usages_f ptu
2557: where per.person_id = p_person_id
2558: and per.person_type_id = pt.person_type_id
2559: and per.person_id = ptu.person_id
2560: and ptu.person_type_id = pt.person_type_id

Line 2773: p_base_table_name => 'PER_PERSON_TYPE_USAGES_F',

2769: */
2770: /*
2771: Get_DT_Upd_Mode
2772: (p_effective_date => p_effective_date,
2773: p_base_table_name => 'PER_PERSON_TYPE_USAGES_F',
2774: p_base_key_column => 'PERSON_TYPE_USAGE_ID',
2775: p_base_key_value => per_per_usg_rec.PERSON_TYPE_USAGE_ID,
2776: p_mode => l_upd_mode);
2777: --