APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 425: pay_balance_dimensions pbd

421: pdb.defined_balance_id def_bal_id
422: from ff_user_entities fue,
423: pay_balance_types pbt,
424: pay_defined_balances pdb,
425: pay_balance_dimensions pbd
426: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
427: and fue.legislation_code = 'SG'
428: and pbt.legislation_code = 'SG'
429: and pbd.legislation_code = pbt.legislation_code

Line 923: pay_balance_dimensions pbd

919: pdb.defined_balance_id def_bal_id
920: from ff_user_entities fue,
921: pay_balance_types pbt,
922: pay_defined_balances pdb,
923: pay_balance_dimensions pbd
924: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
925: and fue.legislation_code = 'SG'
926: and pbt.legislation_code = 'SG'
927: and pbd.legislation_code = pbt.legislation_code

Line 953: pay_balance_dimensions pbd

949: pdb.defined_balance_id def_bal_id
950: from ff_user_entities fue,
951: pay_balance_types pbt,
952: pay_defined_balances pdb,
953: pay_balance_dimensions pbd
954: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
955: and fue.legislation_code = 'SG'
956: and pbt.legislation_code = 'SG'
957: and pbd.legislation_code = pbt.legislation_code

Line 1028: pay_balance_dimensions pbd

1024: pdb.defined_balance_id def_bal_id
1025: from ff_user_entities fue,
1026: pay_balance_types pbt,
1027: pay_defined_balances pdb,
1028: pay_balance_dimensions pbd
1029: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1030: and fue.legislation_code = 'SG'
1031: and pbt.legislation_code = 'SG'
1032: and pbd.legislation_code = pbt.legislation_code