APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 627: pay_balance_dimensions pbd

623: pdb.defined_balance_id def_bal_id
624: from ff_user_entities fue,
625: pay_balance_types pbt,
626: pay_defined_balances pdb,
627: pay_balance_dimensions pbd
628: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
629: and fue.legislation_code = 'SG'
630: and pbt.legislation_code = 'SG'
631: and pbd.legislation_code = pbt.legislation_code

Line 1111: pay_balance_dimensions pbd

1107: pdb.defined_balance_id def_bal_id
1108: from ff_user_entities fue,
1109: pay_balance_types pbt,
1110: pay_defined_balances pdb,
1111: pay_balance_dimensions pbd
1112: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
1113: and fue.legislation_code = 'SG'
1114: and pbt.legislation_code = 'SG'
1115: and pbd.legislation_code = pbt.legislation_code

Line 1198: pay_balance_dimensions pbd

1194: pdb.defined_balance_id def_bal_id
1195: from ff_user_entities fue,
1196: pay_balance_types pbt,
1197: pay_defined_balances pdb,
1198: pay_balance_dimensions pbd
1199: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1200: and fue.legislation_code = 'SG'
1201: and pbt.legislation_code = 'SG'
1202: and pbd.legislation_code = pbt.legislation_code

Line 1940: pay_balance_dimensions pbd

1936: is
1937: select pdb.defined_balance_id
1938: from pay_defined_balances pdb,
1939: pay_balance_types pbt,
1940: pay_balance_dimensions pbd
1941: where pbt.balance_name = c_balance_name
1942: and pbd.dimension_name = '_ASG_LE_RUN'
1943: and pbt.balance_type_id = pdb.balance_type_id
1944: and pbd.balance_dimension_id = pdb.balance_dimension_id