APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 424: pay_defined_balances pdb,

420: select fue.user_entity_id,
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'

Line 922: pay_defined_balances pdb,

918: select fue.user_entity_id,
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'

Line 952: pay_defined_balances pdb,

948: select fue.user_entity_id,
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'

Line 1027: pay_defined_balances pdb,

1023: select fue.user_entity_id,
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'