DBA Data[Home] [Help]

APPS.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on BEN_PERSON_ACTION_ITEMS

Line 1268: from ben_person_action_items per

1264: and actn.language = userenv('LANG')
1265: and popl.actn_typ_id = actn.actn_typ_id
1266: and not exists
1267: (select 'Y'
1268: from ben_person_action_items per
1269: where per.person_id = p_person_id
1270: and per.complete_date is not null
1271: and per.actn_typ_id = actn.actn_typ_id
1272: and popl.once_or_always <> 'ALW'

Line 1288: insert into ben_person_action_items

1284: ,p_effective_date=>p_effective_date
1285: ,p_returned_date=>l_returned_date);
1286: end if;
1287:
1288: insert into ben_person_action_items
1289: (PERSON_ACTION_ITEM_ID
1290: ,ACTN_TYP_ID
1291: ,TRANSACTION_TYPE
1292: ,PERSON_ID

Line 1304: (ben_person_action_items_s.nextval

1300: ,VOID_DATE
1301: ,TRANSACTION_ID
1302: )
1303: values
1304: (ben_person_action_items_s.nextval
1305: ,l_action_items.actn_typ_id
1306: ,'ICD'
1307: ,p_person_id
1308: ,p_assignment_id