APPS.HR_TRANSACTION_SWI dependencies on DUAL

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

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

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

977: open csr_person_details;
978: fetch csr_person_details into step_row;
979: close csr_person_details;
980: hr_utility.set_location(' Closing Cursor:csr_person_details' || l_proc,20);
981: -- Set the Individual fields on the Global Person Record
982: hr_utility.set_location('Setting the GlobalPersonRecord:' || l_proc,25);
983:
984: g_person_ctx.FULL_NAME :=step_row.FULL_NAME;
985: g_person_ctx.PERSON_ID :=step_row.PERSON_ID;

Line 1143: from dual

1139: l_exists char(1);
1140: begin
1141: l_exists := 'N';
1142: select 'Y' into l_exists
1143: from dual
1144: where exists (select 'e'
1145: from wf_notifications wn, wf_message_attributes mat
1146: where wn.notification_id = p_ntfId
1147: and wn.message_name = mat.message_name