DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_RULE_TRANSACTION_TYPE

Line 10822: FROM PSB_RULE_TRANSACTION_TYPE rtt

10818: )
10819: )
10820: /* Bug No 2133484 Start */
10821: AND EXISTS (SELECT 1
10822: FROM PSB_RULE_TRANSACTION_TYPE rtt
10823: WHERE rtt.rule_id = l_rule_id
10824: AND rtt.transaction_type = l_transaction_type
10825: -- Next 1 line added for Bug # 2123930
10826: AND rtt.enable_flag = 'Y'

Line 10990: from psb_rule_transaction_type

10986: /* Bug No 2133484 Start */
10987: --- Commented for the fix done.
10988: /* if l_rule_validation_status = 'S' then
10989: Select count(*) into l_ctr
10990: from psb_rule_transaction_type
10991: where rule_id = c_Brrule_Rec.rule_id
10992: and transaction_type = l_transaction_type
10993: -- Following 1 line added for Bug # 2123930
10994: and enable_flag = 'Y';