APPS.JAI_PA_TAX_PKG dependencies on PA_EVENTS

Line 480: ln_event_type pa_events.event_type%type ;

476:
477: ----------------VARIABLE DECLARATIONS---------------------------
478: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;
479: ln_event_num pa_draft_invoice_items.event_num%type ;
480: ln_event_type pa_events.event_type%type ;
481: ln_event_type_id pa_event_types.event_type_id%type ;
482: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
483:
484: ----------------cursor declarations------------------------------

Line 485: -- responsible for getting event type from pa_events

481: ln_event_type_id pa_event_types.event_type_id%type ;
482: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
483:
484: ----------------cursor declarations------------------------------
485: -- responsible for getting event type from pa_events
486:
487: cursor cur_get_event_type is
488: select pe.event_type
489: from pa_events pe

Line 489: from pa_events pe

485: -- responsible for getting event type from pa_events
486:
487: cursor cur_get_event_type is
488: select pe.event_type
489: from pa_events pe
490: where pe.project_id = pn_project_id and
491: ( pe.task_id = ln_event_task_id or pe.task_id is null ) and
492: pe.event_num = ln_event_num ;
493:

Line 495: -- responsible for getting event type id from pa_events_types

491: ( pe.task_id = ln_event_task_id or pe.task_id is null ) and
492: pe.event_num = ln_event_num ;
493:
494:
495: -- responsible for getting event type id from pa_events_types
496: cursor cur_get_event_type_id is
497: select event_type_id
498: from pa_event_types
499: where event_type = ln_event_type ;