APPS.JAI_PA_TAX_PKG dependencies on PA_EVENTS

Line 491: ln_event_type pa_events.event_type%type ;

487:
488: ----------------VARIABLE DECLARATIONS---------------------------
489: ln_event_task_id pa_draft_invoice_items.event_task_id%type ;
490: ln_event_num pa_draft_invoice_items.event_num%type ;
491: ln_event_type pa_events.event_type%type ;
492: ln_event_type_id pa_event_types.event_type_id%type ;
493: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
494: ln_org_id NUMBER; /*Bug 8348822*/
495:

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

493: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
494: ln_org_id NUMBER; /*Bug 8348822*/
495:
496: ----------------cursor declarations------------------------------
497: -- responsible for getting event type from pa_events
498:
499: cursor cur_get_event_type is
500: select pe.event_type
501: from pa_events pe

Line 501: from pa_events pe

497: -- responsible for getting event type from pa_events
498:
499: cursor cur_get_event_type is
500: select pe.event_type
501: from pa_events pe
502: where pe.project_id = pn_project_id and
503: ( pe.task_id = ln_event_task_id or pe.task_id is null ) and
504: pe.event_num = ln_event_num ;
505:

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

503: ( pe.task_id = ln_event_task_id or pe.task_id is null ) and
504: pe.event_num = ln_event_num ;
505:
506:
507: -- responsible for getting event type id from pa_events_types
508: cursor cur_get_event_type_id is
509: select event_type_id
510: from pa_event_types
511: where event_type = ln_event_type ;