APPS.PA_GET_RESOURCE dependencies on PA_RESOURCES

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 1026: FROM pa_resources par,

1022: par.name,
1023: par.track_as_labor_flag,
1024: par.unit_of_measure,
1025: par.rollup_quantity_flag
1026: FROM pa_resources par,
1027: pa_resource_types part
1028: WHERE part.resource_type_code = 'UNCLASSIFIED'
1029: AND part.resource_type_id = par.resource_type_id;
1030:

Line 1135: , pa_resources r

1131: FROM dual
1132: WHERE exists
1133: (select 'x'
1134: from pa_resource_list_members rlm
1135: , pa_resources r
1136: , pa_resource_types rt
1137: where
1138: rlm.resource_list_id = l_resource_list_id
1139: and rlm.resource_id = r.resource_id