APPS.BEN_EFC_VALIDATION dependencies on BEN_BENEFIT_ACTIONS

Line 110: ben_benefit_actions bft

106: )
107: IS
108: SELECT count(*)
109: FROM ben_batch_ranges bbr,
110: ben_benefit_actions bft
111: WHERE bbr.benefit_action_id = bft.benefit_action_id
112: and bft.business_group_id = c_bg
113: and bbr.range_status_cd = 'U'
114: group by bbr.benefit_action_id;

Line 132: ben_benefit_actions bft

128: bft.no_plans_flag,
129: bft.validate_flag,
130: count(*)
131: FROM ben_person_actions act,
132: ben_benefit_actions bft
133: WHERE act.benefit_action_id = bft.benefit_action_id
134: and bft.business_group_id = c_bg
135: and act.ACTION_STATUS_CD = 'U'
136: and act.non_person_cd is null -- Bug 5042850

Line 338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');

334: --
335: -- Check for unprocessed batch ranges
336: --
337: hr_efc_info.insert_line('-- ');
338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');
339: hr_efc_info.insert_line('-- ');
340: --
341: OPEN csr_find_batch_ranges(l_bgp_id);
342: FETCH csr_find_batch_ranges BULK COLLECT INTO l_bftid_va,

Line 413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');

409: if l_bft_cnt = 0
410: then
411: --
412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');
417: --