APPS.PN_AM_WF dependencies on AME_CALLING_APPS

Line 417: FROM ame_calling_apps

413: l_org_id NUMBER;
414: BEGIN
415: SELECT transaction_type_id
416: INTO l_trx_type
417: FROM ame_calling_apps
418: WHERE application_name = 'PN approval workflow';
419:
420: SELECT f.user_name, pla.lease_num, plda.lease_commencement_date,
421: plda.lease_termination_date

Line 862: FROM ame_calling_apps

858: -- Validate the Transaction Type Id from OAM
859: CURSOR c_validate_trx_type_csr (c_trx_type VARCHAR2)
860: IS
861: SELECT COUNT (*)
862: FROM ame_calling_apps
863: WHERE transaction_type_id = c_trx_type;
864: BEGIN
865: IF (funcmode = 'RUN')
866: THEN