APPS.PA_GET_RESOURCE dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 443: FROM pa_resources a, pa_resource_txn_attributes b

439:
440: CURSOR resource_employee_csr (p_person_id NUMBER, l_resource_type_id NUMBER)
441: IS
442: SELECT a.resource_id
443: FROM pa_resources a, pa_resource_txn_attributes b
444: WHERE a.resource_type_id = l_resource_type_id
445: AND a.resource_id = b.resource_id
446: AND b.person_id = p_person_id;
447:

Line 451: FROM pa_resources a, pa_resource_txn_attributes b

447:
448: CURSOR resource_job_csr (p_job_id NUMBER, l_resource_type_id NUMBER)
449: IS
450: SELECT a.resource_id
451: FROM pa_resources a, pa_resource_txn_attributes b
452: WHERE a.resource_type_id = l_resource_type_id
453: AND a.resource_id = b.resource_id
454: AND b.job_id = p_job_id ;
455:

Line 459: FROM pa_resources a, pa_resource_txn_attributes b

455:
456: CURSOR resource_org_csr (p_proj_organization_id NUMBER, l_resource_type_id NUMBER)
457: IS
458: SELECT a.resource_id
459: FROM pa_resources a, pa_resource_txn_attributes b
460: WHERE a.resource_type_id = l_resource_type_id
461: AND a.resource_id = b.resource_id
462: AND b.organization_id = p_proj_organization_id;
463:

Line 467: FROM pa_resources a, pa_resource_txn_attributes b

463:
464: CURSOR resource_vendor_csr (p_vendor_id NUMBER, l_resource_type_id NUMBER)
465: IS
466: SELECT a.resource_id
467: FROM pa_resources a, pa_resource_txn_attributes b
468: WHERE a.resource_type_id = l_resource_type_id
469: AND a.resource_id = b.resource_id
470: AND b.vendor_id = p_vendor_id;
471:

Line 476: FROM pa_resources a, pa_resource_txn_attributes b

472: CURSOR resource_exp_type_csr (p_expenditure_type VARCHAR2
473: , l_resource_type_id NUMBER)
474: IS
475: SELECT a.resource_id
476: FROM pa_resources a, pa_resource_txn_attributes b
477: WHERE a.resource_type_id = l_resource_type_id
478: AND a.resource_id = b.resource_id
479: AND b.expenditure_type = p_expenditure_type;
480:

Line 484: FROM pa_resources a, pa_resource_txn_attributes b

480:
481: CURSOR resource_event_type_csr (p_event_type VARCHAR2, l_resource_type_id NUMBER)
482: IS
483: SELECT a.resource_id
484: FROM pa_resources a, pa_resource_txn_attributes b
485: WHERE a.resource_type_id = l_resource_type_id
486: AND a.resource_id = b.resource_id
487: AND b.event_type = p_event_type;
488:

Line 493: FROM pa_resources a, pa_resource_txn_attributes b

489: CURSOR resource_exp_cat_csr (p_expenditure_category VARCHAR2
490: , l_resource_type_id NUMBER)
491: IS
492: SELECT a.resource_id
493: FROM pa_resources a, pa_resource_txn_attributes b
494: WHERE a.resource_type_id = l_resource_type_id
495: AND a.resource_id = b.resource_id
496: AND b.expenditure_category = p_expenditure_category;
497:

Line 503: FROM pa_resources a, pa_resource_txn_attributes b

499: CURSOR resource_rev_cat_csr (p_revenue_category_code VARCHAR2
500: , l_resource_type_id NUMBER)
501: IS
502: SELECT a.resource_id
503: FROM pa_resources a, pa_resource_txn_attributes b
504: WHERE a.resource_type_id = l_resource_type_id
505: AND a.resource_id = b.resource_id
506: AND b.revenue_category = p_revenue_category_code;
507:

Line 512: FROM pa_resources a, pa_resource_txn_attributes b

508: CURSOR resource_project_role_csr (p_project_role_id NUMBER
509: , l_resource_type_id NUMBER)
510: IS
511: SELECT a.resource_id
512: FROM pa_resources a, pa_resource_txn_attributes b
513: WHERE a.resource_type_id = l_resource_type_id
514: AND a.resource_id = b.resource_id
515: AND b.project_role_id = p_project_role_id ;
516:

Line 599: p_err_stage := 'Select resource_id from pa_resource_txn_attributes ';

595: -- 22-APR-97, jwhite -----------------------------------------
596: -- Changed code to FETCH hardcoded cursors.
597: --
598:
599: p_err_stage := 'Select resource_id from pa_resource_txn_attributes ';
600:
601: IF (p_resource_type_code = 'EMPLOYEE') THEN
602: OPEN resource_employee_csr (p_person_id, l_resource_type_id);
603: FETCH resource_employee_csr INTO l_resource_id;