18: and a.PRODUCT_TYPE = l_product;
19: --
20: cursor CPARTY_LEVEL_ADV is
21: select a.CLIENT_ADVICE
22: from XTR_PARTY_INFO_V a
23: where a.PARTY_CODE = l_cparty;
24: --
25: cursor CLIENT_LEVEL_ADV is
26: select a.CLIENT_ADVICE
23: where a.PARTY_CODE = l_cparty;
24: --
25: cursor CLIENT_LEVEL_ADV is
26: select a.CLIENT_ADVICE
27: from XTR_PARTY_INFO_V a
28: where a.PARTY_CODE = l_client;
29: --
30: begin
31: open PROD_LEVEL_ADV;
742: and AUTHORISED = 'Y';
743: --
744: cursor QRY_NAME is
745: select SHORT_NAME
746: from XTR_PARTY_INFO_V
747: where PARTY_CODE = l_client_code;
748: --
749: begin
750: if nvl(l_query,'N') = 'Y' then
787: and c.company_authorised_for_input='Y');
788: --
789: cursor QRY_NAME is
790: select p.SHORT_NAME
791: from XTR_PARTY_INFO_V p
792: where p.PARTY_CODE = l_company_code;
793: --
794: begin
795: fnd_user := fnd_global.user_id;
854: and AUTHORISED = 'Y';
855: --
856: cursor QRY_NAME is
857: select SHORT_NAME
858: from XTR_PARTY_INFO_V
859: where PARTY_CODE = l_cparty_code;
860: --
861: begin
862: if nvl(l_query,'N') = 'Y' then