APPS.PAY_MX_PAYREG_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 879: FROM pay_balance_dimensions

875: WHERE ppa.payroll_action_id = pactid;
876:
877: CURSOR c_get_balance_dimensions (dimtype varchar2)is
878: SELECT balance_dimension_id
879: FROM pay_balance_dimensions
880: WHERE database_item_suffix = dimtype
881: AND legislation_code = 'MX';
882:
883: CURSOR c_get_assig_act_id (pactid number

Line 904: pay_balance_dimensions pbd,

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'
908: ,'Deductions'

Line 935: pay_balance_dimensions pbd,

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'
939: ,'Deductions'

Line 966: pay_balance_dimensions pbd,

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'
970: ,'Deductions'