DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PAY_DEFINED_BALANCES

Line 178: FROM pay_defined_balances pdb,

174:
175: CURSOR get_def_bal( c_bal_name VARCHAR2
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

Line 392: pay_defined_balances pdb,

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%'
396: AND pbad.business_group_id IS NULL

Line 420: pay_defined_balances pdb,

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,
424: fnd_lookup_values hrl