DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on DUAL

Line 101: --RCHASE for individuals without assignments

97: p_pl_typ_id => p_pl_typ_id,
98: p_per_cm_id => p_per_cm_id,
99: p_jurisdiction_code => l_jurisdiction_code,
100: --RCHASE Bug Fix - Formula requires person_id as input value
101: --RCHASE for individuals without assignments
102: p_param1 =>'PERSON_ID',
103: p_param1_value =>to_char(p_person_id)
104: );
105: --

Line 2027: from sys.dual

2023: and ctu.all_r_any_cd in ('ALL','ANY');
2024: --
2025: cursor c2 is
2026: select null
2027: from sys.dual
2028: where not exists (select null
2029: from ben_elig_per_elctbl_chc epe
2030: where epe.business_group_id = p_business_group_id
2031: and epe.elctbl_flag = 'Y'