APPS.BEN_BENEFIT_CONTRIBUTIONS_PKG dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

Line 48: from ben_benefit_contributions_f

44: foreign key is used, thus the cursor applies to any
45: parent entity. */
46: --
47: select *
48: from ben_benefit_contributions_f
49: where p_parent_id = decode (p_parent_name,
50: 'PAY_ELEMENT_TYPES_F', element_type_id,
51: 'PER_BUSINESS_GROUPS', business_group_id,
52: 'PER_COBRA_COVERAGE_BENEFITS_F',coverage_type)

Line 69: delete from ben_benefit_contributions_f

65: or (p_delete_mode = 'DELETE'
66: and p_session_date < fetched_benefit_contribution.effective_start_date )
67: then
68: --
69: delete from ben_benefit_contributions_f
70: where current of csr_orphaned_rows;
71: --
72: -- For date effective deletions, the current children of the now closed parent
73: -- must have their end dates updated to match that of the parent

Line 80: update ben_benefit_contributions_f

76: and p_session_date between fetched_benefit_contribution.effective_start_date
77: and fetched_benefit_contribution.effective_end_date)
78: then
79: --
80: update ben_benefit_contributions_f
81: set effective_end_date = p_session_date
82: where current of csr_orphaned_rows;
83: --
84: end if;