DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on PSP_AUTO_LOOKUPS

Line 61: FROM psp_auto_lookups b

57:
58: CURSOR LOOKUPS_C IS
59: SELECT b.lookup_id, b.parameter,b.datatype,
60: b.dyn_sql_stmt, b.bind_var
61: FROM psp_auto_lookups b
62: where business_group_id=p_business_group_id
63: and set_of_books_id=p_set_of_books_id
64: order by lookup_id;
65:

Line 636: (select lookup_id from psp_auto_lookups where

632: a.operand, a.user_value
633: FROM psp_auto_params a
634: WHERE a.acct_id = p_acct_id
635: and exists
636: (select lookup_id from psp_auto_lookups where
637: lookup_id=a.lookup_id);
638:
639: CURSOR rules_c(p_acct_id IN NUMBER) IS
640: SELECT calculator_rule