APPS.PA_RESOURCE_LIST_PKG dependencies on PA_RESOURCES

Line 87: PA_RESOURCES PR,

83: l_resource_format_id,
84: l_resource_type_id,
85: l_res_type_code
86: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
87: PA_RESOURCES PR,
88: PA_RESOURCE_TYPES PRT
89: WHERE prta.resource_id = pr.resource_id
90: AND pr.resource_id =X_RESOURCE_ID
91: AND pr.resource_type_id= prt.resource_type_id;

Line 351: PA_RESOURCES PR,

347: l_resource_format_id,
348: l_resource_type_id,
349: l_res_type_code
350: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
351: PA_RESOURCES PR,
352: PA_RESOURCE_TYPES PRT
353: WHERE prta.resource_id(+) = pr.resource_id
354: AND pr.resource_id =X_RESOURCE_ID
355: AND pr.resource_type_id= prt.resource_type_id;