APPS.PV_PROCESS_RULE_PVT dependencies on PV_PROCESS_RULES_TL

Line 627: from fnd_profile_option_values a, pv_process_rules_tl b,

623: -- SQL is tuned to make use of an index on fnd_profile_option_values
624: -- ------------------------------------------------------------------------
625: cursor lc_validate_rule_profile_ref(pc_rule_id number) is
626: select process_rule_name
627: from fnd_profile_option_values a, pv_process_rules_tl b,
628: fnd_profile_options c
629: where a.profile_option_value = to_char(pc_rule_id)
630: and a.profile_option_value = b.process_rule_id AND
631: b.language = USERENV('LANG') and

Line 1033: From PV_PROCESS_RULES_B RLSB,PV_PROCESS_RULES_TL RLST

1029: RLSB.PROGRAM_UPDATE_DATE, PROCESS_RULE_NAME, PARENT_RULE_ID, PROCESS_TYPE , RANK, STATUS_CODE, START_DATE, END_DATE,
1030: ACTION, ACTION_VALUE, OWNER_RESOURCE_ID, CURRENCY_CODE, LANGUAGE, SOURCE_LANG ,DESCRIPTION, ATTRIBUTE_CATEGORY,
1031: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
1032: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1033: From PV_PROCESS_RULES_B RLSB,PV_PROCESS_RULES_TL RLST
1034: where RLSB.process_rule_id = RLST.process_rule_id and
1035: (RLSB.parent_rule_id = pc_process_rule_id or RLSB.process_rule_id = pc_process_rule_id) and
1036: RLST.language = USERENV('LANG') order by parent_rule_id desc;
1037: