APPS.PAY_US_941_REPORT dependencies on PAY_BALANCE_DIMENSIONS

Line 409: pay_balance_dimensions pbd

405: IS
406: SELECT pdb.defined_balance_id
407: FROM pay_defined_balances pdb,
408: pay_balance_types pbt,
409: pay_balance_dimensions pbd
410: WHERE pbt.balance_name = cp_balance_name
411: AND pbt.legislation_code = 'US'
412: AND pbd.database_item_suffix = cp_balance_dimension
413: AND pbd.legislation_code = 'US'

Line 534: pay_balance_dimensions pbd

530: SELECT pdb.defined_balance_id
531: INTO ln_def_bal_id
532: FROM pay_defined_balances pdb,
533: pay_balance_types pbt,
534: pay_balance_dimensions pbd
535: WHERE pbt.balance_name = 'Gross Earnings'
536: AND pbt.legislation_code = 'US'
537: AND pbd.database_item_suffix = '_ASG_QTD'
538: AND pbd.legislation_code = 'US'

Line 743: from pay_balance_dimensions

739: from pay_balance_types
740: where balance_name = 'SS ER W11 Taxable'
741: and legislation_code = 'US')
742: and balance_dimension_id = (select balance_dimension_id
743: from pay_balance_dimensions
744: where database_item_suffix = '_ASG_GRE_RUN'
745: and legislation_code = 'US');
746:
747: open c_run_balance_valid (p_business_group_id, ln_defined_balance_id);