APPS.HR_TRANSACTION_SWI dependencies on DUAL

Line 875: -- Set the Individual fields on the Global Transaction Context Record

871: fetch csr_hat into step_row;
872: close csr_hat;
873: hr_utility.set_location(' Closing Cursor:csr_hat' || l_proc,20);
874:
875: -- Set the Individual fields on the Global Transaction Context Record
876: hr_utility.set_location(' Setting GlobalTxnCtx' || l_proc,25);
877: g_txn_ctx.TRANSACTION_ID :=step_row.TRANSACTION_ID;
878: g_txn_ctx.CREATOR_PERSON_ID :=step_row.CREATOR_PERSON_ID;
879: g_txn_ctx.STATUS :=step_row.STATUS;

Line 995: -- Set the Individual fields on the Global Person Record

991: open csr_person_details;
992: fetch csr_person_details into step_row;
993: close csr_person_details;
994: hr_utility.set_location(' Closing Cursor:csr_person_details' || l_proc,20);
995: -- Set the Individual fields on the Global Person Record
996: hr_utility.set_location('Setting the GlobalPersonRecord:' || l_proc,25);
997:
998: g_person_ctx.FULL_NAME :=step_row.FULL_NAME;
999: g_person_ctx.PERSON_ID :=step_row.PERSON_ID;

Line 1256: from dual

1252: l_exists char(1);
1253: begin
1254: l_exists := 'N';
1255: select 'Y' into l_exists
1256: from dual
1257: where exists (select 'e'
1258: from wf_notifications wn, wf_message_attributes mat
1259: where wn.notification_id = p_ntfId
1260: and wn.message_name = mat.message_name