APPS.BEN_CWB_PERSON_RATES_API dependencies on HR_LOOKUPS

Line 725: l_cd_meaning_old hr_lookups.meaning%type;

721:
722: l_rates_new csr_rates%rowtype;
723: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
724: l_object_version_number ben_cwb_audit.object_version_number%type;
725: l_cd_meaning_old hr_lookups.meaning%type;
726: l_cd_meaning_new hr_lookups.meaning%type;
727: l_person_id fnd_user.employee_id%type;
728:
729: begin

Line 726: l_cd_meaning_new hr_lookups.meaning%type;

722: l_rates_new csr_rates%rowtype;
723: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
724: l_object_version_number ben_cwb_audit.object_version_number%type;
725: l_cd_meaning_old hr_lookups.meaning%type;
726: l_cd_meaning_new hr_lookups.meaning%type;
727: l_person_id fnd_user.employee_id%type;
728:
729: begin
730:

Line 1051: from hr_lookups

1047: if(ben_cwb_audit_api.return_lookup_validity('EL')=true) then
1048:
1049: begin
1050: select meaning into l_cd_meaning_old
1051: from hr_lookups
1052: where lookup_type='BEN_CWB_ELIG_CRITERIA'
1053: and lookup_code = p_rates_old.elig_flag;
1054: exception
1055: when no_data_found then

Line 1062: from hr_lookups

1058: end;
1059:
1060: begin
1061: select meaning into l_cd_meaning_new
1062: from hr_lookups
1063: where lookup_type='BEN_CWB_ELIG_CRITERIA'
1064: and lookup_code = l_rates_new.elig_flag;
1065: exception
1066: when no_data_found then

Line 1096: from hr_lookups

1092: if(ben_cwb_audit_api.return_lookup_validity('ER')=true) then
1093:
1094: begin
1095: select meaning into l_cd_meaning_old
1096: from hr_lookups
1097: where lookup_type='BEN_INELG_RSN'
1098: and lookup_code = p_rates_old.inelig_rsn_cd;
1099: exception
1100: when no_data_found then

Line 1107: from hr_lookups

1103: end;
1104:
1105: begin
1106: select meaning into l_cd_meaning_new
1107: from hr_lookups
1108: where lookup_type='BEN_INELG_RSN'
1109: and lookup_code = l_rates_new.inelig_rsn_cd;
1110: exception
1111: when no_data_found then