DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PAY_DEFINED_BALANCES

Line 161: FROM pay_defined_balances pdb,

157:
158: CURSOR get_def_bal( c_bal_name VARCHAR2
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

Line 375: pay_defined_balances pdb,

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

Line 403: pay_defined_balances pdb,

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