APPS.PA_RES_ACCUMS dependencies on PA_RESOURCE_TXN_ATTRIBUTES

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

738: -- This procedure will return the resource and its attributes for the
739: -- given project_id. It will return the group level resource for
740: -- the resources for which no child resource exists and for the
741: -- group if child exists then it will return only the childs
742: -- please note that outer join is done for pa_resources to pa_resource_txn_attributes
743: -- because some of the resource may not have attributes
744:
745: -- x_resource_list_id IN OUT resource_list_id_tabtype,
746: -- x_resource_list_assignment_id IN OUT resource_list_asgn_id_tabtype,

Line 805: pa_resource_txn_attributes rta,

801: , rl.job_group_id
802: FROM
803: pa_resource_lists_all_bg rl,
804: pa_resource_list_members rlm,
805: pa_resource_txn_attributes rta,
806: pa_resources r,
807: pa_resource_types rt,
808: pa_resource_list_assignments rla
809: WHERE

Line 857: pa_resource_txn_attributes rtac,

853: FROM
854: pa_resource_lists_all_bg rl,
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,
860: pa_resource_types rtc,
861: pa_resource_list_assignments rla

Line 858: pa_resource_txn_attributes rtap,

854: pa_resource_lists_all_bg rl,
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,
860: pa_resource_types rtc,
861: pa_resource_list_assignments rla
862: WHERE