[Home] [Help]
402: CURSOR c_non_gms_ap_trans IS
403: SELECT gl.packet_id
404: FROM ap_invoice_distributions_all ap,
405: gms_award_distributions adl,
406: pa_projects_all pp,
407: gms_project_types gpt,
408: gl_bc_packets gl
409: WHERE gl.packet_id = p_packet_id
410: AND gl.je_source_name = 'Payables'
431:
432: CURSOR c_non_gms_ap IS
433: SELECT gl.packet_id
434: FROM ap_invoice_distributions_all ap,
435: pa_projects_all pp,
436: gms_project_types gpt,
437: gl_bc_packets gl
438: WHERE gl.packet_id = p_packet_id
439: AND gl.je_source_name = 'Payables'
448: AND gpt.sponsored_flag = 'Y';
449:
450: CURSOR c_non_gms_req IS
451: SELECT gl.packet_id
452: FROM pa_projects_all pp,
453: gms_project_types gpt,
454: po_req_distributions_all pord,
455: gl_bc_packets gl
456: WHERE gl.packet_id = p_packet_id
464:
465: CURSOR c_non_gms_ip is
466: SELECT gl.packet_id
467: FROM gl_bc_packets gl,
468: pa_projects pp,
469: gms_project_types gpt
470: WHERE gl.packet_id = p_packet_id
471: AND pp.project_id = TO_NUMBER (gl.reference7)
472: AND pp.project_type = gpt.project_type
474: AND NVL (gl.reference6, 'XXXXX') = 'GMSIP' ;
475:
476: CURSOR c_non_gms_po IS
477: SELECT gl.packet_id
478: FROM po_distributions_all pod, pa_projects_all pp, gms_project_types gpt, gl_bc_packets gl
479: WHERE gl.packet_id = p_packet_id
480: AND gl.reference1 = 'PO'
481: AND gl.template_id IS NULL
482: AND gl.reference3 = pod.po_distribution_id