APPS.HXC_SETUP_VALIDATION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

SELECT
	DISTINCT( rrc.time_recipient_id )
FROM
	hxc_retrieval_rule_comps rrc
,	hxc_retrieval_rules rr
,	hxc_retrieval_rule_grp_comps_v rrgc
,	hxc_retrieval_rule_groups_v rrg
WHERE
	rrg.retrieval_rule_group_id  = p_rtr_grp_id
AND
	rrgc.retrieval_rule_group_id = rrg.retrieval_rule_group_id
AND
	rr.retrieval_rule_id	= rrgc.retrieval_rule_id
AND
	rrc.retrieval_rule_id	= rr.retrieval_rule_id AND
	rrc.status <> 'WORKING';

Line: 61

SELECT
	DISTINCT( rrc.time_recipient_id )
FROM
	hxc_retrieval_rule_comps rrc
,	hxc_retrieval_rules rr
WHERE
	rr.retrieval_rule_id	= p_rtr_id
AND
	rrc.retrieval_rule_id	= rr.retrieval_rule_id AND
	rrc.status <> 'WORKING';

Line: 76

SELECT	apsc.time_recipient_id
FROM	hxc_application_set_comps_v apsc
,	hxc_application_sets_v aps
WHERE	aps.application_set_id = p_app_set_id
AND
	apsc.application_set_id = aps.application_set_id;

Line: 89

SELECT	'Y'
FROM	hxc_approval_period_comps hapc,
        hxc_approval_period_sets haps
WHERE	haps.approval_period_set_id = p_app_periods
AND
	hapc.approval_period_set_id = haps.approval_period_set_id AND
	hapc.time_recipient_id      = p_time_recipient_id;

Line: 104

SELECT	'Y'
FROM	hxc_approval_comps hac,
	hxc_approval_styles has
WHERE	hac.approval_style_id = p_approval_style_id
AND	hac.time_recipient_id = p_time_recipient_id
OR      (has.approval_style_id = p_approval_style_id
         AND has.name	      = 'Approval on Submit');

Line: 115

SELECT  /*+ ORDERED
           INDEX(hte hxc_time_entry_rules_pk)*/
	'Y'
FROM    hxc_entity_groups heg,
        hxc_entity_group_comps hec,
	hxc_time_entry_rules hte
WHERE   heg.entity_type = 'TIME_ENTRY_RULES' and
        heg.entity_group_id = p_elp_terg_id and
	hec.ENTITY_GROUP_ID =heg.entity_group_id and
        hec.entity_id = hte.TIME_ENTRY_RULE_ID and
	hte.attribute1 = p_time_recipient_id;

Line: 133

 select approval_status
 from hxc_timecard_summary
 where timecard_id = p_timecard_bb_id
 and timecard_ovn =p_timecard_bb_ovn;

Line: 473

    SELECT COUNT(1)
      INTO l_pay_tr_exists
      FROM hxc_time_recipients
     WHERE time_recipient_id = l_aps_tr_id
       AND application_id    = 801; -- Payroll

Line: 635

	t_rtr_tr.DELETE;

Line: 994

          p_preference_code       => 'TC_W_DELETE_ALLOW',
          p_start_evaluation_date => l_timecard_info_rec.start_date,
          p_end_evaluation_date   => l_timecard_info_rec.end_date,
          p_sorted_pref_table     => l_pref_table,
          p_master_pref_table     => p_master_pref_table );

Line: 1013

       end if; -- Delete Allowed ?