APPS.FUN_TCA_PKG SQL Statements

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

Line: 25

select match_rule_id into p_x_rule_id from hz_match_rules_vl where rule_name='IC_PARTY_SEARCH';

Line: 63

 SELECT count(1)
 INTO l_count_le
 FROM  xle_firstparty_information_v FAL
 WHERE  FAL.party_id = p_party_id;

Line: 71

	 SELECT   hzr.object_id
	     INTO    l_le_id
	     FROM    hz_relationships hzr
	     WHERE   HZR.subject_id=p_party_id
		     AND     hzr.subject_table_name='HZ_PARTIES'
		     AND     hzr.object_table_name='HZ_PARTIES'
		     AND     hzr.relationship_code='INTERCOMPANY_ORGANIZATION_OF'
		     AND     hzr.relationship_type='INTERCOMPANY_LEGAL_ENTITY'
		     AND     hzr.directional_flag='F'
		     AND     hzr.status='A'
		     AND     TRUNC(start_date) <= nvl(p_as_date  ,sysdate)
		     AND     (TRUNC(end_date) >= nvl(p_as_date,sysdate) OR end_date IS NULL);

Line: 99

 SELECT   hzr.subject_id into l_ou_id
	 FROM	    hz_relationships hzr
	 WHERE   HZR.object_id=p_party_id
	    AND     hzr.subject_table_name='HR_ALL_ORGANIZATION_UNITS'
	    AND     hzr.object_table_name='HZ_PARTIES'
 	    AND     hzr.relationship_type='INTERCOMPANY_OPERATING_UNIT'
	    AND	    hzr.relationship_code='OPERATING_UNIT_OF'
	    AND     hzr.directional_flag='B'
	    AND     hzr.status='A'
	    AND     TRUNC(start_date) <=nvl(p_as_date  ,sysdate)
	    AND     (TRUNC(end_date) >= nvl(p_as_date  ,sysdate) OR end_date IS NULL);

Line: 129

	SELECT orig_system_reference
	INTO l_sys_ref
	FROM hz_parties
	WHERE party_id = p_party_id;

Line: 149

	SELECT status
	INTO l_status
	FROM hz_parties
	WHERE party_id=p_party_id;

Line: 156

	SELECT status_flag
      INTO l_status
	FROM 	  hz_party_usg_assignments hua
	WHERE   hua.party_id = p_party_id
	AND     hua.party_usage_code = 'INTERCOMPANY_ORG';

Line: 162

	SELECT          status
		INTO l_status
	 		FROM 	  HZ_CODE_ASSIGNMENTS hca
			WHERE  	  hca.owner_table_id=p_party_id
			AND	  hca.class_category='INTERCOMPANY'
			AND	  hca.class_code ='INTERCOMPANY'
			AND	  hca.owner_table_name='HZ_PARTIES' ;

Line: 186

	SELECT status
	INTO l_status
	FROM hz_parties
	WHERE party_id=p_party_id;

Line: 193

	SELECT status_flag
      INTO l_status
	FROM 	  hz_party_usg_assignments hua
	WHERE   hua.party_id = p_party_id
	AND     hua.party_usage_code = 'INTERCOMPANY_ORG'
	AND     hua.effective_start_date <= NVL(p_as_date, sysdate)
      AND     (hua.effective_end_date >= NVL(p_as_date, sysdate) OR effective_end_date IS NULL);

Line: 201

/*	SELECT          status
		INTO l_status
	 		FROM 	  HZ_CODE_ASSIGNMENTS hca
			WHERE  	  hca.owner_table_id=p_party_id
			AND	  hca.class_category='INTERCOMPANY'
			AND	  hca.class_code ='INTERCOMPANY'
			AND	  hca.owner_table_name='HZ_PARTIES'
			AND 	  start_date_active<=nvl(p_as_date  ,sysdate)
			AND 	  (end_date_active >= nvl(p_as_date  ,sysdate) OR end_date_active IS NULL);

Line: 225

SELECT hua.effective_start_date, hua.effective_end_date
	FROM 	  hz_party_usg_assignments hua
	WHERE   hua.party_id = p_party_id
    AND hua.party_usage_code = 'INTERCOMPANY_ORG'
    AND hua.effective_start_date = (
				SELECT max(effective_start_date)
                FROM hz_party_usg_assignments
				WHERE   party_id = p_party_id
                AND party_usage_code = 'INTERCOMPANY_ORG'
                );

Line: 306

SELECT 'Y'
	FROM hz_parties h, hz_party_usg_assignments hua
	WHERE h.party_name = l_party_name
    AND hua.party_id = h.party_id
    AND hua.party_usage_code = 'INTERCOMPANY_ORG';