APPS.BEN_CWB_PERSON_GROUPS_API dependencies on HR_LOOKUPS

Line 582: l_cd_meaning_old hr_lookups.meaning%type;

578: l_grp_bdgt_new csr_grps%rowtype;
579: l_pl_dsgn ben_cwb_pl_dsgn%rowtype;
580: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
581: l_object_version_number ben_cwb_audit.object_version_number%type;
582: l_cd_meaning_old hr_lookups.meaning%type;
583: l_cd_meaning_new hr_lookups.meaning%type;
584: l_proc varchar2(72) := g_package||'create_audit_record';
585: l_person_id fnd_user.employee_id%type;
586:

Line 583: l_cd_meaning_new hr_lookups.meaning%type;

579: l_pl_dsgn ben_cwb_pl_dsgn%rowtype;
580: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
581: l_object_version_number ben_cwb_audit.object_version_number%type;
582: l_cd_meaning_old hr_lookups.meaning%type;
583: l_cd_meaning_new hr_lookups.meaning%type;
584: l_proc varchar2(72) := g_package||'create_audit_record';
585: l_person_id fnd_user.employee_id%type;
586:
587: begin

Line 804: from hr_lookups

800: if(ben_cwb_audit_api.return_lookup_validity('SU')=true) then
801:
802: begin
803: select meaning into l_cd_meaning_old
804: from hr_lookups
805: where lookup_type='BEN_SUBMIT_STAT'
806: and lookup_code=p_grp_bdgt_old.submit_cd;
807: exception
808: when no_data_found then

Line 814: from hr_lookups

810: end;
811:
812: begin
813: select meaning into l_cd_meaning_new
814: from hr_lookups
815: where lookup_type='BEN_SUBMIT_STAT'
816: and lookup_code=l_grp_bdgt_new.submit_cd;
817: exception
818: when no_data_found then

Line 852: from hr_lookups

848:
849:
850: begin
851: select meaning into l_cd_meaning_old
852: from hr_lookups
853: where lookup_type='BEN_APPR_STAT'
854: and lookup_code=p_grp_bdgt_old.approval_cd;
855: exception
856: when no_data_found then

Line 862: from hr_lookups

858: end;
859:
860: begin
861: select meaning into l_cd_meaning_new
862: from hr_lookups
863: where lookup_type='BEN_APPR_STAT'
864: and lookup_code=l_grp_bdgt_new.approval_cd;
865: exception
866: when no_data_found then

Line 952: from hr_lookups

948: if(ben_cwb_audit_api.return_lookup_validity('AC')=true) then
949:
950: begin
951: select meaning into l_cd_meaning_old
952: from hr_lookups
953: where lookup_type='BEN_WS_ACC'
954: and lookup_code=p_grp_bdgt_old.access_cd;
955: exception
956: when no_data_found then

Line 962: from hr_lookups

958: end;
959:
960: begin
961: select meaning into l_cd_meaning_new
962: from hr_lookups
963: where lookup_type='BEN_WS_ACC'
964: and lookup_code=l_grp_bdgt_new.access_cd;
965: exception
966: when no_data_found then