APPS.HZ_EXTRACT_ORG_CUST_BO_PVT dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 700: elsif p_child_entity_name = 'HZ_CUST_ACCT_RELATE_ALL' then

696: then PX_CUST_ACCT_OBJ.BANK_ACCT_USE_OBJS(i).action_type := p_action_type;
697: l_child_upd_flag := 'Y';
698: end if;
699: end loop;
700: elsif p_child_entity_name = 'HZ_CUST_ACCT_RELATE_ALL' then
701: for i in 1..PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS.COUNT
702: loop
703: -- bug 8654754: cust_acct_relate_id is not a attribute in acct relate obj.
704: select cust_acct_relate_id into l_cust_acct_relate_id

Line 705: from HZ_CUST_ACCT_RELATE_ALL

701: for i in 1..PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS.COUNT
702: loop
703: -- bug 8654754: cust_acct_relate_id is not a attribute in acct relate obj.
704: select cust_acct_relate_id into l_cust_acct_relate_id
705: from HZ_CUST_ACCT_RELATE_ALL
706: where cust_account_id = PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS(i).cust_acct_id
707: and related_cust_account_id = PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS(i).related_cust_acct_id
708: --and relationship_type = PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS(i).relationship_type -- bug 13871410
709: and nvl(relationship_type,'null') = nvl(PX_CUST_ACCT_OBJ.ACCT_RELATE_OBJS(i).relationship_type, 'null')

Line 1879: elsif p_child_entity_name = 'HZ_CUST_ACCT_RELATE_ALL' then

1875: then px_cust_acct_v2_obj.BANK_ACCT_USE_OBJS(i).action_type := p_action_type;
1876: l_child_upd_flag := 'Y';
1877: end if;
1878: end loop;
1879: elsif p_child_entity_name = 'HZ_CUST_ACCT_RELATE_ALL' then
1880: for i in 1..px_cust_acct_v2_obj.ACCT_RELATE_OBJS.COUNT
1881: loop
1882: if px_cust_acct_v2_obj.ACCT_RELATE_OBJS(i).RELATED_CUST_ACCT_ID = p_child_id
1883: then px_cust_acct_v2_obj.ACCT_RELATE_OBJS(i).action_type := p_action_type;