APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 620: pay_balance_dimensions pbd

616: pdb.defined_balance_id def_bal_id
617: from ff_user_entities fue,
618: pay_balance_types pbt,
619: pay_defined_balances pdb,
620: pay_balance_dimensions pbd
621: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
622: and fue.legislation_code = 'SG'
623: and pbt.legislation_code = 'SG'
624: and pbd.legislation_code = pbt.legislation_code

Line 1100: pay_balance_dimensions pbd

1096: pdb.defined_balance_id def_bal_id
1097: from ff_user_entities fue,
1098: pay_balance_types pbt,
1099: pay_defined_balances pdb,
1100: pay_balance_dimensions pbd
1101: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
1102: and fue.legislation_code = 'SG'
1103: and pbt.legislation_code = 'SG'
1104: and pbd.legislation_code = pbt.legislation_code

Line 1187: pay_balance_dimensions pbd

1183: pdb.defined_balance_id def_bal_id
1184: from ff_user_entities fue,
1185: pay_balance_types pbt,
1186: pay_defined_balances pdb,
1187: pay_balance_dimensions pbd
1188: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1189: and fue.legislation_code = 'SG'
1190: and pbt.legislation_code = 'SG'
1191: and pbd.legislation_code = pbt.legislation_code

Line 1929: pay_balance_dimensions pbd

1925: is
1926: select pdb.defined_balance_id
1927: from pay_defined_balances pdb,
1928: pay_balance_types pbt,
1929: pay_balance_dimensions pbd
1930: where pbt.balance_name = c_balance_name
1931: and pbd.dimension_name = '_ASG_LE_RUN'
1932: and pbt.balance_type_id = pdb.balance_type_id
1933: and pbd.balance_dimension_id = pdb.balance_dimension_id