APPS.PO_ASL_API_PVT dependencies on PO_ASL_DOCUMENTS_GT

Line 485: FROM po_asl_documents_gt

481: program_application_id ,
482: program_id ,
483: program_update_date ,
484: org_id
485: FROM po_asl_documents_gt
486: WHERE user_key IN
487: (SELECT user_key
488: FROM po_approved_supplier_list_gt
489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

Line 980: FROM po_asl_documents_gt PADGT,

976: PADGT.request_id ,
977: PADGT.program_application_id ,
978: PADGT.program_id ,
979: PADGT.program_update_date
980: FROM po_asl_documents_gt PADGT,
981: po_approved_supplier_list_gt ASLGT
982: WHERE PADGT.user_key = ASLGT.user_key
983: AND PADGT.asl_id = PAD.asl_id
984: AND PADGT.using_organization_id = PAD.using_organization_id

Line 991: FROM po_asl_documents_gt PADGT,

987: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
988: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
989: WHERE (PAD.asl_id, PAD.using_organization_id, PAD.document_header_id) IN
990: (SELECT PADGT.asl_id, PADGT.using_organization_id, PADGT.document_header_id
991: FROM po_asl_documents_gt PADGT,
992: po_approved_supplier_list_gt ASLGT
993: WHERE PADGT.user_key = ASLGT.user_key
994: AND PADGT.asl_id = PAD.asl_id
995: AND PADGT.using_organization_id = PAD.using_organization_id

Line 1269: FROM po_asl_documents_gt PADGT,

1265: WHERE (asl_id,using_organization_id,document_header_id) IN
1266: (SELECT PADGT.asl_id ,
1267: PADGT.using_organization_id ,
1268: PADGT.document_header_id
1269: FROM po_asl_documents_gt PADGT,
1270: po_approved_supplier_list_gt ASLGT
1271: WHERE ASLGT.user_key = PADGT.user_key
1272: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1273: AND PADGT.asl_id = PAD.asl_id