APPS.PAY_IE_LE_MIGRATE dependencies on PAY_DEFINED_BALANCES

Line 72: ,pay_defined_balances def_old

68: ,def_new.defined_balance_id new_id
69: FROM pay_balance_types pbt
70: ,pay_balance_dimensions dim_old
71: ,pay_balance_dimensions dim_new
72: ,pay_defined_balances def_old
73: ,pay_defined_balances def_new
74: WHERE pbt.balance_name = p_balance_name
75: AND dim_old.database_item_suffix = '_PER_PAYE_REF_YTD'
76: AND dim_old.legislation_code = 'IE'

Line 73: ,pay_defined_balances def_new

69: FROM pay_balance_types pbt
70: ,pay_balance_dimensions dim_old
71: ,pay_balance_dimensions dim_new
72: ,pay_defined_balances def_old
73: ,pay_defined_balances def_new
74: WHERE pbt.balance_name = p_balance_name
75: AND dim_old.database_item_suffix = '_PER_PAYE_REF_YTD'
76: AND dim_old.legislation_code = 'IE'
77: AND dim_new.legislation_code = 'IE'

Line 434: ,pay_defined_balances def_old

430: ,def_new.defined_balance_id new_id
431: FROM pay_balance_types pbt
432: ,pay_balance_dimensions dim_old
433: ,pay_balance_dimensions dim_new
434: ,pay_defined_balances def_old
435: ,pay_defined_balances def_new
436: WHERE pbt.balance_name = p_balance_name
437: AND dim_old.database_item_suffix = '_PER_YTD'
438: AND dim_old.legislation_code = 'IE'

Line 435: ,pay_defined_balances def_new

431: FROM pay_balance_types pbt
432: ,pay_balance_dimensions dim_old
433: ,pay_balance_dimensions dim_new
434: ,pay_defined_balances def_old
435: ,pay_defined_balances def_new
436: WHERE pbt.balance_name = p_balance_name
437: AND dim_old.database_item_suffix = '_PER_YTD'
438: AND dim_old.legislation_code = 'IE'
439: AND dim_new.legislation_code = 'IE'