DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on DUAL

Line 94: --RCHASE for individuals without assignments

90: p_pl_typ_id => p_pl_typ_id,
91: p_per_cm_id => p_per_cm_id,
92: p_jurisdiction_code => l_jurisdiction_code,
93: --RCHASE Bug Fix - Formula requires person_id as input value
94: --RCHASE for individuals without assignments
95: p_param1 =>'PERSON_ID',
96: p_param1_value =>to_char(p_person_id)
97: );
98: --

Line 1788: from sys.dual

1784: and ctu.all_r_any_cd in ('ALL','ANY');
1785: --
1786: cursor c2 is
1787: select null
1788: from sys.dual
1789: where not exists (select null
1790: from ben_elig_per_elctbl_chc epe
1791: where epe.business_group_id = p_business_group_id
1792: and epe.elctbl_flag = 'Y'