DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on PAY_DEFINED_BALANCES

Line 903: FROM pay_defined_balances pdb_call,

899: CURSOR c_get_def_bal_id is
900: SELECT DISTINCT fue_live.user_entity_name,
901: fue_live.creator_id,
902: 0 tmp_bal_value
903: FROM pay_defined_balances pdb_call,
904: pay_balance_dimensions pbd,
905: pay_balance_types pbt,
906: ff_user_entities fue_live
907: WHERE pbt.balance_name IN ('Earnings'

Line 934: FROM pay_defined_balances pdb_call,

930: CURSOR c_get_def_bal_id_mtd is
931: SELECT DISTINCT fue_live.user_entity_name,
932: fue_live.creator_id,
933: 0 tmp_bal_value
934: FROM pay_defined_balances pdb_call,
935: pay_balance_dimensions pbd,
936: pay_balance_types pbt,
937: ff_user_entities fue_live
938: WHERE pbt.balance_name IN ('Earnings'

Line 965: FROM pay_defined_balances pdb_call,

961: CURSOR c_get_def_bal_id_ytd is
962: SELECT DISTINCT fue_live.user_entity_name,
963: fue_live.creator_id,
964: 0 tmp_bal_value
965: FROM pay_defined_balances pdb_call,
966: pay_balance_dimensions pbd,
967: pay_balance_types pbt,
968: ff_user_entities fue_live
969: WHERE pbt.balance_name IN ('Earnings'