APPS.BEN_EXT_CHLG dependencies on BEN_BENFTS_GRP

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

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

Line 471: from ben_benfts_grp bbg

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

Line 505: l_old_benefits_group ben_benfts_grp.name%type;

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

Line 506: l_new_benefits_group ben_benfts_grp.name%type;

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