APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 150: l_bal_name pay_balance_types.balance_name%type;

146: ,p_state_code IN VARCHAR2 DEFAULT NULL
147: ,p_fit_wh_bal_flag IN VARCHAR2 DEFAULT 'N' )
148: RETURN NUMBER IS
149: --+
150: l_bal_name pay_balance_types.balance_name%type;
151: l_dim_name pay_balance_dimensions.dimension_name%type;
152: l_def_bal_id number;
153: l_amt number;
154: l_tax_unit_id varchar2(30);

Line 167: FROM pay_balance_types pbt,

163: AND lookup_type = 'PQP_US_ALIEN_INCOME_BALANCE';
164: --+
165: CURSOR c_defined_bal IS
166: SELECT pdb.defined_balance_id
167: FROM pay_balance_types pbt,
168: pay_defined_balances pdb,
169: pay_balance_dimensions pbd
170: WHERE pbt.balance_name = l_bal_name
171: AND pbt.balance_type_id = pdb.balance_type_id

Line 348: pay_balance_types pbt,

344:
345: CURSOR c1 (c_balance_name varchar2, c_dimension_name varchar2) IS
346: SELECT defined_balance_id
347: FROM pay_defined_balances pdb,
348: pay_balance_types pbt,
349: pay_balance_dimensions pbd
350: WHERE pdb.balance_type_id = pbt.balance_type_id
351: AND pdb.balance_dimension_id = pbd.balance_dimension_id
352: AND pbt.balance_name = c_balance_name

Line 577: l_bal_name pay_balance_types.balance_name%type;

573:
574: l_dimension pay_balance_dimensions.dimension_name%type;
575: l_defined_bal_id NUMBER;
576: l_def_pre_tax_id NUMBER;
577: l_bal_name pay_balance_types.balance_name%type;
578: l_bal_amt NUMBER;
579: l_asg_action_id NUMBER;
580: ---------------------------------------+
581: -- Funtion to get the defined balance Id

Line 597: FROM pay_balance_types blt

593: SELECT dbl.defined_balance_id
594: FROM pay_defined_balances dbl
595: WHERE dbl.balance_type_id =
596: (SELECT balance_type_id
597: FROM pay_balance_types blt
598: WHERE blt.balance_name = p_bal_name
599: AND blt.legislation_code = 'US')
600: AND dbl.balance_dimension_id =
601: (SELECT balance_dimension_id