APPS.PAY_MX_TRR_PKG dependencies on PAY_BALANCE_TYPES

Line 180: pay_balance_types pbt

176: ,c_data_suffix VARCHAR2) IS
177: SELECT pdb.defined_balance_id def_bal
178: FROM pay_defined_balances pdb,
179: pay_balance_dimensions pbd,
180: pay_balance_types pbt
181: WHERE pbt.balance_type_id = pdb.balance_type_id
182: AND pbd.balance_dimension_id = pdb.balance_dimension_id
183: AND pbd.database_item_suffix = c_data_suffix
184: AND pbt.balance_name = c_bal_name

Line 391: FROM pay_balance_types pbt,

387: -- CURSOR to get state earnings details
388: CURSOR get_state_details (p_state VARCHAR2) IS
389: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
390: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
391: FROM pay_balance_types pbt,
392: pay_defined_balances pdb,
393: pay_balance_attributes pba,
394: pay_bal_attribute_definitions pbad
395: WHERE pbad.attribute_name LIKE 'Tax Remittance%'

Line 419: FROM pay_balance_types pbt,

415: rtrim(substr(pbt.balance_name,
416: length(pbt.balance_name)-1)) ee_or_er,
417: pli.legislation_info4 soc_sec_tax_pct_ee,
418: pli.legislation_info5 soc_sec_tax_pct_er
419: FROM pay_balance_types pbt,
420: pay_defined_balances pdb,
421: pay_balance_attributes pba,
422: pay_bal_attribute_definitions pbad,
423: pay_mx_legislation_info_f pli,