APPS.PAY_MX_TRR_PKG dependencies on PAY_BALANCE_TYPES

Line 163: pay_balance_types pbt

159: ,c_data_suffix VARCHAR2) IS
160: SELECT pdb.defined_balance_id def_bal
161: FROM pay_defined_balances pdb,
162: pay_balance_dimensions pbd,
163: pay_balance_types pbt
164: WHERE pbt.balance_type_id = pdb.balance_type_id
165: AND pbd.balance_dimension_id = pdb.balance_dimension_id
166: AND pbd.database_item_suffix = c_data_suffix
167: AND pbt.balance_name = c_bal_name

Line 374: FROM pay_balance_types pbt,

370: -- CURSOR to get state earnings details
371: CURSOR get_state_details (p_state VARCHAR2) IS
372: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
373: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
374: FROM pay_balance_types pbt,
375: pay_defined_balances pdb,
376: pay_balance_attributes pba,
377: pay_bal_attribute_definitions pbad
378: WHERE pbad.attribute_name LIKE 'Tax Remittance%'

Line 402: FROM pay_balance_types pbt,

398: rtrim(substr(pbt.balance_name,
399: length(pbt.balance_name)-1)) ee_or_er,
400: pli.legislation_info4 soc_sec_tax_pct_ee,
401: pli.legislation_info5 soc_sec_tax_pct_er
402: FROM pay_balance_types pbt,
403: pay_defined_balances pdb,
404: pay_balance_attributes pba,
405: pay_bal_attribute_definitions pbad,
406: pay_mx_legislation_info_f pli,