DBA Data[Home] [Help]

APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_APPROVAL_PERIOD_SETS

Line 91: hxc_approval_period_sets haps

87: CURSOR csr_get_app_rec_period(p_time_recipient_id number,
88: p_app_periods number) is
89: SELECT 'Y'
90: FROM hxc_approval_period_comps hapc,
91: hxc_approval_period_sets haps
92: WHERE haps.approval_period_set_id = p_app_periods
93: AND
94: hapc.approval_period_set_id = haps.approval_period_set_id AND
95: hapc.time_recipient_id = p_time_recipient_id;