APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 151: l_dim_name pay_balance_dimensions.dimension_name%type;

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);
155: l_boolean boolean := TRUE;

Line 169: pay_balance_dimensions pbd

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
172: AND pbd.balance_dimension_id = pdb.balance_dimension_id
173: AND pbd.dimension_name = l_dim_name

Line 343: l_dimension_name pay_balance_dimensions.dimension_name%type;

339: RETURN NUMBER IS
340:
341: l_balance_amount NUMBER;
342: l_defined_balance_id NUMBER;
343: l_dimension_name pay_balance_dimensions.dimension_name%type;
344:
345: CURSOR c1 (c_balance_name varchar2, c_dimension_name varchar2) IS
346: SELECT defined_balance_id
347: FROM pay_defined_balances pdb,

Line 349: pay_balance_dimensions pbd

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
353: AND pbd.dimension_name = c_dimension_name

Line 574: l_dimension pay_balance_dimensions.dimension_name%type;

570: -- Cursor to get all the processed assignemtns in
571: -- a given GRE withing a date range
572: --
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;

Line 602: FROM pay_balance_dimensions bld

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
602: FROM pay_balance_dimensions bld
603: WHERE bld.database_item_suffix =
604: '_'|| p_dimension
605: AND bld.legislation_code = 'US')
606: AND dbl.legislation_code = 'US';