APPS.BEN_EFC_FUNCTIONS dependencies on HR_EFC_ACTIONS

Line 71: FROM hr_efc_actions act

67: )
68: IS
69: SELECT act.efc_action_id,
70: act.business_group_id
71: FROM hr_efc_actions act
72: WHERE act.efc_action_status = 'P'
73: AND act.efc_action_type = 'C'
74: and act.business_group_id = c_bgp_id;
75:

Line 223: from hr_efc_actions

219: if p_action_id is not null then
220: --
221: select business_group_id
222: into l_business_group_id
223: from hr_efc_actions
224: where efc_action_id = p_action_id;
225: --
226: elsif p_bgp_id is not null then
227: --

Line 541: FROM hr_efc_actions

537: (c_bgp_id in number
538: )
539: IS
540: SELECT 'Y'
541: FROM hr_efc_actions
542: WHERE efc_action_status = 'P'
543: and business_group_id = c_bgp_id;
544: --
545: CURSOR csr_fetch_id

Line 547: SELECT hr_efc_actions_s.nextval

543: and business_group_id = c_bgp_id;
544: --
545: CURSOR csr_fetch_id
546: IS
547: SELECT hr_efc_actions_s.nextval
548: FROM dual;
549: --
550: CURSOR csr_get_sequence
551: (c_bg IN number

Line 555: FROM hr_efc_actions

551: (c_bg IN number
552: )
553: IS
554: SELECT max(action_sequence)
555: FROM hr_efc_actions
556: WHERE business_group_id = c_bg;
557: --
558: CURSOR csr_find_lowest_phase
559: IS

Line 599: INSERT INTO hr_efc_actions

595: ELSE
596: l_max := l_max +1;
597: END IF;
598: --
599: INSERT INTO hr_efc_actions
600: (efc_action_id
601: ,efc_action_type
602: ,efc_action_status
603: ,efc_progress_status

Line 657: from hr_efc_actions efc

653: (c_bgp_id in number
654: )
655: IS
656: select efc.efc_action_id
657: from hr_efc_actions efc
658: where efc.business_group_id = c_bgp_id;
659: --
660: BEGIN
661: --

Line 695: delete from hr_efc_actions

691: --
692: delete from HR_EFC_ROUNDING_ERRORS
693: where efc_action_id = l_efc_action_id;
694: --
695: delete from hr_efc_actions
696: where efc_action_id = l_efc_action_id;
697: --
698: commit;
699: --