APPS.PA_RBS_UTILS dependencies on FND_LOOKUP_VALUES

Line 546: fnd_lookup_values c

542: FND_GLOBAL.LOGIN_ID
543: FROM
544: pa_rbs_element_names_b a,
545: pa_rbs_elem_in_temp b,
546: fnd_lookup_values c
547: WHERE a.resource_source_id = b.resource_source_id
548: AND a.resource_type_id = p_resource_type_id
549: AND b.resource_type_id = p_resource_type_id
550: AND c.lookup_type = 'RBS_RULE_RESOURCE'

Line 661: fnd_lookup_values lk,

657: FND_GLOBAL.LOGIN_ID
658: FROM
659: pa_rbs_element_names_b a,
660: pa_rbs_elem_in_temp b,
661: fnd_lookup_values lk,
662: /* Changes for Bug 3780201 start*/
663: pa_rbs_element_map c
664: WHERE a.resource_source_id = b.resource_source_id
665: and a.resource_type_id = p_resource_type_id

Line 861: fnd_lookup_values lk

857: FROM
858: pa_rbs_element_names_b a,
859: pa_rbs_elem_in_temp b,
860: Pa_rbs_element_map c,
861: fnd_lookup_values lk
862: WHERE a.resource_source_id = b.resource_source_id
863: AND a.resource_type_id = p_resource_type_id
864: AND b.resource_type_id = p_resource_type_id
865: and c.resource_id = a.resource_source_id

Line 1629: fnd_lookup_values lk,

1625: sysdate,
1626: fnd_global.user_id,
1627: fnd_global.login_id
1628: FROM --pa_lookups lk,
1629: fnd_lookup_values lk,
1630: pa_rbs_element_names_b a
1631: WHERE
1632: a.resource_type_id = -2
1633: and a.resource_source_id = -1

Line 2129: fnd_lookup_values lk,

2125: sysdate,
2126: fnd_global.user_id,
2127: fnd_global.login_id
2128: FROM pa_rbs_element_map map,-- For bug 3799582
2129: fnd_lookup_values lk,
2130: pa_rbs_element_names_b a
2131: WHERE map.resource_type_id = a.resource_type_id
2132: AND a.resource_source_id=map.resource_id
2133: AND a.resource_type_id=11

Line 2248: FROM fnd_lookup_values lk,

2244: fnd_global.user_id,
2245: sysdate,
2246: fnd_global.user_id,
2247: fnd_global.login_id
2248: FROM fnd_lookup_values lk,
2249: pa_rbs_element_names_b a,
2250: pa_rbs_element_map map
2251: WHERE a.resource_source_id=map.resource_id
2252: AND map.resource_name=lk.lookup_code