DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 52: from pay_balance_types

48: Cursor csr_get_pay_bal_id
49: (c_balance_name varchar2
50: ) is
51: select balance_type_id
52: from pay_balance_types
53: where balance_name = c_balance_name
54: and nvl(business_group_id, g_business_group_id) =
55: g_business_group_id
56: and legislation_code = 'GB';

Line 58: g_add_cont_bal_id pay_balance_types.balance_type_id%type;

54: and nvl(business_group_id, g_business_group_id) =
55: g_business_group_id
56: and legislation_code = 'GB';
57:
58: g_add_cont_bal_id pay_balance_types.balance_type_id%type;
59:
60: -- Cursor to get element type ids from balance
61: --ENH2:The business group check was removed and business group id was
62: --added in the select.This was done so that we pick up all the