APPS.CS_CHARGE_DETAILS_PVT dependencies on AR_LOOKUPS

Line 509: SELECT meaning from ar_lookups

505:
506: --Cursor to check return reason code
507:
508: CURSOR c_return_reason_cur(p_return_reason_code varchar2) is
509: SELECT meaning from ar_lookups
510: WHERE lookup_type = 'CREDIT_MEMO_REASON'
511: and lookup_code = p_return_reason_code;
512:
513: lv_exists_flag VARCHAR2(1) := 'N';

Line 768: ar_lookups ar,

764: SELECT rel.party_id
765: FROM hz_relationships party_rel,
766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,
770: hz_relationship_types typ,
771: hz_code_assignments asg
772: WHERE party_rel.object_id = p_party_id

Line 769: ar_lookups relm,

765: FROM hz_relationships party_rel,
766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,
770: hz_relationship_types typ,
771: hz_code_assignments asg
772: WHERE party_rel.object_id = p_party_id
773: AND party_rel.party_id = rel.party_id

Line 816: ar_lookups ar,

812: SELECT rel.party_id
813: FROM hz_relationships party_rel,
814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,
818: hz_relationship_types typ,
819: hz_code_assignments asg
820: WHERE party_rel.object_id = p_party_id

Line 817: ar_lookups relm,

813: FROM hz_relationships party_rel,
814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,
818: hz_relationship_types typ,
819: hz_code_assignments asg
820: WHERE party_rel.object_id = p_party_id
821: AND party_rel.party_id = rel.party_id