APPS.PAY_US_PSD_XML dependencies on PAY_BALANCE_TYPES

Line 232: pay_balance_types pbt

228: cp_balance_dimension in varchar2 ) is
229: select pdb.defined_balance_id
230: from pay_defined_balances pdb,
231: pay_balance_dimensions pbd,
232: pay_balance_types pbt
233: where pbt.balance_name = cp_balance_name
234: and pbd.database_item_suffix= cp_balance_dimension
235: and pbt.balance_type_id = pdb.balance_type_id
236: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2617: ln_balance_type_id pay_balance_types.balance_type_id%type;

2613: --ln_year NUMBER := 0;
2614: ln_psd_count NUMBER := 0;
2615:
2616: lv_balance_name VARCHAR2(80);
2617: ln_balance_type_id pay_balance_types.balance_type_id%type;
2618:
2619: cursor c_get_min_chunk is
2620: select min(paa.chunk_number)
2621: from pay_assignment_actions paa

Line 2627: from pay_balance_types pbt,

2623:
2624:
2625: cursor c_get_psd_balances is
2626: select flv.meaning, pbt.balance_type_id
2627: from pay_balance_types pbt,
2628: fnd_application fa,
2629: fnd_lookup_values flv,
2630: fnd_lookup_types flt
2631: where pbt.legislation_code = 'US'

Line 2812: ln_balance_type_id pay_balance_types.balance_type_id%type;

2808: l_psd_balance_value number(15,2):=0;
2809:
2810: /* Local variables to archive PSD balances*/
2811: lv_balance_name VARCHAR2(80);
2812: ln_balance_type_id pay_balance_types.balance_type_id%type;
2813: lv_balance_dimension VARCHAR2(80);
2814: ln_qtd_def_bal_id pay_defined_balances.defined_balance_id%type;
2815: ln_month_def_bal_id pay_defined_balances.defined_balance_id%type;
2816: ln_city_wk_def_bal_id pay_defined_balances.defined_balance_id%type;