APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 4530: ap_system_parameters_all asp ---7209263 added automatic offsets flag

4526: ac.org_id,
4527: ac.payment_type_flag,
4528: asp.automatic_offsets_flag
4529: FROM ap_checks_all ac,
4530: ap_system_parameters_all asp ---7209263 added automatic offsets flag
4531: WHERE ac.check_id = p_check_id
4532: AND ac.org_id=asp.org_id;
4533:
4534: l_accounting_event_id NUMBER;

Line 4568: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263

4564: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4565:
4566: l_event_type xla_events.event_type_code%TYPE;
4567: l_pay_type ap_checks_all.payment_type_flag%TYPE;
4568: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263
4569: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
4570:
4571:
4572: BEGIN

Line 4822: FROM AP_CHECKS AC, ap_system_parameters_all asp

4818: l_creation_date,
4819: l_last_updated_by,
4820: l_org_id,
4821: l_automatic_offsets_flag --7209263
4822: FROM AP_CHECKS AC, ap_system_parameters_all asp
4823: WHERE AC.check_id = l_pay_clear_check_ids(i) --bug 7278341 l_pay_check_ids(i)
4824: AND AC.org_id=asp.org_id;
4825: */
4826: --bug 7607184

Line 4984: FROM AP_CHECKS AC, ap_system_parameters_all asp

4980: l_creation_date,
4981: l_last_updated_by,
4982: l_org_id,
4983: l_automatic_offsets_flag --7209263
4984: FROM AP_CHECKS AC, ap_system_parameters_all asp
4985: WHERE AC.check_id = l_pay_mat_check_ids(i)--bug 7278341 l_pay_check_ids(i)
4986: AND AC.org_id=asp.org_id;
4987:
4988:

Line 5736: ap_system_parameters_all ASP

5732: ( SELECT ASP.org_id
5733: FROM hr_organization_information OI,
5734: --hr_all_organization_units_tl LE, --bug6392886
5735: hr_all_organization_units_tl OU,
5736: ap_system_parameters_all ASP
5737: WHERE ASP.org_id = OI.organization_id
5738: AND OU.organization_id = OI.organization_id
5739: AND OI.org_information_context = 'Operating Unit Information'
5740: AND DECODE(LTRIM(OI.org_information3, '0123456789'), NULL,

Line 5767: ap_system_parameters_all ASP

5763: ( SELECT ASP.org_id
5764: FROM hr_organization_information OI,
5765: --hr_all_organization_units_tl LE, --bug6392886
5766: hr_all_organization_units_tl OU,
5767: ap_system_parameters_all ASP
5768: WHERE ASP.org_id = OI.organization_id
5769: AND OU.organization_id = OI.organization_id
5770: AND OI.org_information_context = 'Operating Unit Information'
5771: AND DECODE(LTRIM(OI.org_information3, '0123456789'), NULL,

Line 5806: ap_system_parameters_all ASP

5802: ( SELECT ASP.org_id
5803: FROM hr_organization_information OI,
5804: --hr_all_organization_units_tl LE, --bug6392886
5805: hr_all_organization_units_tl OU,
5806: ap_system_parameters_all ASP
5807: WHERE ASP.org_id = OI.organization_id
5808: AND OU.organization_id = OI.organization_id
5809: AND OI.org_information_context = 'Operating Unit Information'
5810: AND DECODE(LTRIM(OI.org_information3,'0123456789'), NULL,

Line 5844: ap_system_parameters_all ASP

5840: ( SELECT ASP.org_id
5841: FROM hr_organization_information OI,
5842: --hr_all_organization_units_tl LE, bug6392886
5843: hr_all_organization_units_tl OU,
5844: ap_system_parameters_all ASP
5845: WHERE ASP.org_id = OI.organization_id
5846: AND OU.organization_id = OI.organization_id
5847: AND OI.org_information_context = 'Operating Unit Information'
5848: AND DECODE(LTRIM(OI.org_information3,'0123456789'), NULL,

Line 6995: ap_system_parameters_all ASP --bug6705052

6991: INTO p_org_id,
6992: p_legal_entity_id,
6993: p_ledger_id
6994: FROM ap_checks_all AC, --bug6705052
6995: ap_system_parameters_all ASP --bug6705052
6996: WHERE AC.check_id = p_check_id
6997: AND nvl(AC.org_id,-99) = nvl(ASP.org_id,-99);
6998:
6999: l_log_msg :='End of procedure '||l_procedure_name;