APPS.AR_ARXCCS_XMLP_PKG dependencies on AR_COLLECTORS

Line 810: FROM ar_collectors;

806:
807: if p_collector_low is NULL then
808: SELECT min(name)
809: INTO l_collector_min
810: FROM ar_collectors;
811:
812: p_collector_min:= l_collector_min ;
813:
814: /*srw.message (100, 'DEBUG: Collector Name (MIN): ' || p_collector_min);*/null;

Line 821: from ar_collectors;

817:
818: if p_collector_high is NULL then
819: SELECT max(name)
820: into l_collector_max
821: from ar_collectors;
822:
823: p_collector_max := l_collector_max ;
824:
825: /*srw.message (100, 'DEBUG: Collector Name (MAX): ' || p_collector_max);*/null;

Line 933: ar_collectors coll,

929: l_cred_summ_exempt_dun,
930: l_cred_summ_collector,
931: l_customer_profile_id
932: from hz_customer_profiles cp,
933: ar_collectors coll,
934: ar_lookups lk,
935: ra_terms term
936: where cp.collector_id = coll.collector_id
937: and cp.standard_terms = term.term_id (+)

Line 970: ar_collectors coll,

966: l_cred_summ_collector,
967: l_customer_profile_id
968:
969: from hz_customer_profiles cp,
970: ar_collectors coll,
971: ar_lookups lk,
972: ra_terms term
973:
974: where cp.collector_id = coll.collector_id