DBA Data[Home] [Help]

APPS.GHR_PDI_API dependencies on DUAL

Line 137: from dual;

133: from ghr_groupboxes gbx
134: where gbx.groupbox_id = l_2_groupbox_id;
135: Cursor c_item_key_seq is
136: select ghr_pd_wf_item_key_s.nextval
137: from dual;
138:
139: BEGIN
140: hr_utility.set_location('Now Entering:'||l_proc, 5);
141: -- Issue a savepoint if operating in validation only mode.

Line 726: from dual;

722: from ghr_groupboxes gbx
723: where gbx.groupbox_id = l_next_groupbox_id;
724: Cursor c_item_key_seq is
725: select ghr_pd_wf_item_key_s.nextval
726: from dual;
727: BEGIN
728: hr_utility.set_location('Entering'||l_proc,5);
729: --
730: -- Issue a savepoint if operating in validation mode.

Line 1359: from dual;

1355: from ghr_groupboxes gbx
1356: where gbx.groupbox_id = l_groupbox_id_1;
1357: Cursor c_item_key_seq is
1358: select ghr_pd_wf_item_key_s.nextval
1359: from dual;
1360: cursor c_cnt_history is
1361: select count(*) cnt
1362: from ghr_pd_routing_history pdh
1363: where pdh.position_description_id = p_position_description_id;