APPS.CS_CHARGE_DETAILS_PVT dependencies on AR_LOOKUPS

Line 490: SELECT meaning from ar_lookups

486:
487: --Cursor to check return reason code
488:
489: CURSOR c_return_reason_cur(p_return_reason_code varchar2) is
490: SELECT meaning from ar_lookups
491: WHERE lookup_type = 'CREDIT_MEMO_REASON'
492: and lookup_code = p_return_reason_code;
493:
494: lv_exists_flag VARCHAR2(1) := 'N';

Line 746: ar_lookups ar,

742: SELECT rel.party_id
743: FROM hz_relationships party_rel,
744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,
748: hz_relationship_types typ,
749: hz_code_assignments asg
750: WHERE party_rel.object_id = p_party_id

Line 747: ar_lookups relm,

743: FROM hz_relationships party_rel,
744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,
748: hz_relationship_types typ,
749: hz_code_assignments asg
750: WHERE party_rel.object_id = p_party_id
751: AND party_rel.party_id = rel.party_id

Line 779: ar_lookups ar,

775: SELECT rel.party_id
776: FROM hz_relationships party_rel,
777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,
781: hz_relationship_types typ,
782: hz_code_assignments asg
783: WHERE party_rel.object_id = p_party_id

Line 780: ar_lookups relm,

776: FROM hz_relationships party_rel,
777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,
781: hz_relationship_types typ,
782: hz_code_assignments asg
783: WHERE party_rel.object_id = p_party_id
784: AND party_rel.party_id = rel.party_id