DBA Data[Home] [Help]

APPS.XTR_FPS1_P dependencies on XTR_PARTIES_V

Line 738: from XTR_PARTIES_V

734: l_level OUT NOCOPY VARCHAR2) is
735: --
736: cursor PTY_NAME is
737: select SHORT_NAME
738: from XTR_PARTIES_V
739: where PARTY_CODE = l_client_code
740: and PARTY_TYPE = 'CP'
741: and PARTY_CATEGORY = 'CL'
742: and AUTHORISED = 'Y';

Line 780: from XTR_PARTIES_V p

776: where user_id = fnd_user;
777:
778: cursor COMP_NAME(l_user VARCHAR2) is
779: select p.SHORT_NAME
780: from XTR_PARTIES_V p
781: where p.PARTY_CODE = l_company_code
782: and p.PARTY_TYPE = 'C'
783: and p.AUTHORISED = 'Y'
784: and p.party_code in(select c.party_code

Line 851: from XTR_PARTIES_V

847: l_level OUT NOCOPY VARCHAR2) is
848: --
849: cursor PTY_NAME is
850: select SHORT_NAME
851: from XTR_PARTIES_V
852: where PARTY_CODE = l_cparty_code
853: and PARTY_TYPE in('CP','C')
854: and AUTHORISED = 'Y';
855: --