APPS.BEN_EXT_CHLG dependencies on BEN_BENFTS_GRP

Line 467: cursor c_benefits_group(p_benfts_grp_id ben_benfts_grp.benfts_grp_id%type)

463: from hr_lookups hl
464: where hl.lookup_type = p_lookup_type
465: and hl.lookup_code = p_lookup_code;
466:
467: cursor c_benefits_group(p_benfts_grp_id ben_benfts_grp.benfts_grp_id%type)
468: is
469: select name
470: from ben_benfts_grp bbg
471: where bbg.benfts_grp_id = p_benfts_grp_id;

Line 470: from ben_benfts_grp bbg

466:
467: cursor c_benefits_group(p_benfts_grp_id ben_benfts_grp.benfts_grp_id%type)
468: is
469: select name
470: from ben_benfts_grp bbg
471: where bbg.benfts_grp_id = p_benfts_grp_id;
472: --
473: cursor c_relationship(p_person_id number) is
474: SELECT pcr.contact_relationship_id,pcr.person_id

Line 504: l_old_benefits_group ben_benfts_grp.name%type;

500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;

Line 505: l_new_benefits_group ben_benfts_grp.name%type;

501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;
509: l_new_ethnic_group hr_lookups.meaning%type ;