APPS.PAY_GB_RTI_EYU dependencies on PAY_BALANCE_DIMENSIONS

Line 958: pay_balance_dimensions pbd,

954:
955: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
956: select pdb.defined_balance_id from
957: pay_defined_balances pdb,
958: pay_balance_dimensions pbd,
959: pay_balance_types pbt
960: where pbt.balance_name = c_balance_name
961: and pbd.database_item_suffix = c_dim_name
962: and pbt.balance_type_id= pdb.balance_type_id

Line 1305: pay_balance_dimensions pbd,

1301: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1302:
1303: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
1304: select pdb.defined_balance_id from pay_defined_balances pdb,
1305: pay_balance_dimensions pbd,
1306: pay_balance_types pbt
1307: where pbt.balance_name = c_balance_name
1308: and pbd.database_item_suffix = c_dim_name
1309: and pbt.balance_type_id= pdb.balance_type_id

Line 4632: pay_balance_dimensions d

4628: IS
4629: SELECT defined_balance_id
4630: FROM pay_defined_balances db,
4631: pay_balance_types b,
4632: pay_balance_dimensions d
4633: WHERE b.balance_name = p_balance_name
4634: AND d.dimension_name = p_dimension_name
4635: AND db.balance_type_id = b.balance_type_id
4636: AND db.balance_dimension_id = d.balance_dimension_id

Line 4650: pay_balance_dimensions d

4646: d.balance_dimension_id balance_dimension_id,
4647: db.defined_balance_id defined_balance_id
4648: FROM pay_defined_balances db,
4649: pay_balance_types b,
4650: pay_balance_dimensions d
4651: WHERE db.balance_type_id = b.balance_type_id
4652: AND db.balance_dimension_id = d.balance_dimension_id
4653:
4654: AND (d.database_item_suffix = '_ASG_TD_YTD'

Line 4673: pay_balance_dimensions d

4669: d.balance_dimension_id balance_dimension_id,
4670: db.defined_balance_id defined_balance_id
4671: FROM pay_defined_balances db,
4672: pay_balance_types b,
4673: pay_balance_dimensions d
4674: WHERE db.balance_type_id = b.balance_type_id
4675: AND db.balance_dimension_id = d.balance_dimension_id
4676: AND ((d.database_item_suffix = '_PER_TD_YTD'
4677: AND b.balance_name IN ('Taxable Pay','Student Loan','SSP Total','SMP Total',

Line 4698: pay_balance_dimensions d

4694: d.balance_dimension_id balance_dimension_id,
4695: db.defined_balance_id defined_balance_id
4696: FROM pay_defined_balances db,
4697: pay_balance_types b,
4698: pay_balance_dimensions d
4699: WHERE db.balance_type_id = b.balance_type_id
4700: AND db.balance_dimension_id = d.balance_dimension_id
4701:
4702: AND (d.database_item_suffix = '_ASG_TD_YTD'

Line 4723: pay_balance_dimensions d

4719: d.balance_dimension_id balance_dimension_id,
4720: db.defined_balance_id defined_balance_id
4721: FROM pay_defined_balances db,
4722: pay_balance_types b,
4723: pay_balance_dimensions d
4724: WHERE db.balance_type_id = b.balance_type_id
4725: AND db.balance_dimension_id = d.balance_dimension_id
4726:
4727: AND (d.database_item_suffix = '_PER_TD_YTD'