APPS.GMS_RES_MAP dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 2558: -- please note that outer join is done for pa_resources to pa_resource_txn_attributes

2554: -- This procedure will return the resource and its attributes for the
2555: -- given project_id. It will return the group level resource for
2556: -- the resources for which no child resource exists and for the
2557: -- group if child exists then it will return only the childs
2558: -- please note that outer join is done for pa_resources to pa_resource_txn_attributes
2559: -- because some of the resource may not have attributes
2560:
2561: PROCEDURE get_mappable_resources
2562: ( x_project_id IN NUMBER,

Line 2615: pa_resource_txn_attributes rta,

2611: rt.resource_type_code
2612: FROM
2613: pa_resource_lists rl,
2614: pa_resource_list_members rlm,
2615: pa_resource_txn_attributes rta,
2616: pa_resources r,
2617: pa_resource_types rt,
2618: pa_resource_list_assignments rla
2619: WHERE

Line 2667: pa_resource_txn_attributes rtac,

2663: FROM
2664: pa_resource_lists rl,
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,
2671: pa_resource_list_assignments rla

Line 2668: pa_resource_txn_attributes rtap,

2664: pa_resource_lists rl,
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,
2671: pa_resource_list_assignments rla
2672: WHERE