APPS.PAY_GB_PERSON_TITLE_UPDATE dependencies on PER_BUSINESS_GROUPS

Line 21: FROM per_business_groups

17:
18: -- To get business_group name
19: CURSOR csr_business_group is
20: SELECT name
21: FROM per_business_groups
22: WHERE business_group_id =p_bg_id;
23:
24: -- To get person details
25: CURSOR csr_person_det is

Line 41: l_business_group_name per_business_groups.name%type;

37: order by ppf.person_id;
38:
39: -- Local variables.
40: l_new_title varchar2(15);
41: l_business_group_name per_business_groups.name%type;
42: l_no_data_found varchar2(1);
43: l_full_name varchar2(100);
44: l_comment_id number;
45: l_person_id per_people_f.person_id%type;