DBA Data[Home] [Help]

APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RULE_GROUPS_V

Line 184: l_retrieval_rule_grp_id hxc_retrieval_rule_groups_v.retrieval_rule_group_id%TYPE;

180: l_edited_days t_edited_days;
181: days_tab t_absences;
182: hours_tab t_absences;
183: l_abs_retrieval_rule VARCHAR2 (50);
184: l_retrieval_rule_grp_id hxc_retrieval_rule_groups_v.retrieval_rule_group_id%TYPE;
185: l_emp_name per_all_people_f.full_name%TYPE;
186: l_temp_row hxc_abs_ret_temp%ROWTYPE;
187: l_count NUMBER;
188: l_days_ix NUMBER;

Line 2776: hxc_retrieval_rule_groups_v rrg

2772: INTO l_ret_status
2773: FROM hxc_retrieval_rule_comps rrc,
2774: hxc_retrieval_rules rr,
2775: hxc_retrieval_rule_grp_comps_v rrgc,
2776: hxc_retrieval_rule_groups_v rrg
2777: WHERE rrg.retrieval_rule_group_id = p_retrieval_rule_grp_id
2778: AND rrgc.retrieval_rule_group_id = rrg.retrieval_rule_group_id
2779: AND rrgc.retrieval_process_id = g_retrieval_process_id
2780: AND rr.retrieval_rule_id = rrgc.retrieval_rule_id