APPS.FV_GTAS_GL_PKG dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1741: FROM hz_cust_accounts_all

1737: log(l_module_name,'12.2 or above, using dynamic select');
1738: l_select := ' SELECT cust_account_id, account_name,
1739: NVL(federal_entity_type,''N''),
1740: trading_partner_agency_id
1741: FROM hz_cust_accounts_all
1742: WHERE cust_account_id = :party_id';
1743: EXECUTE IMMEDIATE l_select
1744: INTO p_party_info_tab(i).party_id,
1745: p_party_info_tab(i).party_name,

Line 1777: FROM hz_cust_accounts_all c

1773: p_party_info_tab(i).fed_nonfed_code ,
1774: p_party_info_tab(i).agency_id ,
1775: P_party_info_tab(i).party_line_amount,
1776: p_party_info_tab(i).doc_num
1777: FROM hz_cust_accounts_all c
1778: WHERE c.cust_account_id = other_source_rec.party_id;
1779:
1780: END IF;
1781: END IF;

Line 1856: FROM hz_cust_accounts_all c

1852: p_party_info_tab(i).fed_nonfed_code ,
1853: p_party_info_tab(i).agency_id ,
1854: p_party_info_tab(i).party_line_amount,
1855: p_party_info_tab(i).doc_num
1856: FROM hz_cust_accounts_all c
1857: WHERE c.cust_account_id = project_source_rec.party_id;
1858: END IF;
1859: ELSE
1860: p_party_info_tab(i).party_line_amount := project_source_rec.amount;

Line 2152: FROM hz_cust_accounts_all c

2148: p_party_info_tab(i).party_type ,
2149: p_party_info_tab(i).party_name,
2150: p_party_info_tab(i).fed_nonfed_code ,
2151: p_party_info_tab(i).agency_id
2152: FROM hz_cust_accounts_all c
2153: WHERE c.cust_account_id = to_number(p_reference7);
2154: END IF;
2155: --Get the receivables doc num
2156: IF UPPER(p_je_category) like '%RECEIPTS%' THEN