[Home] [Help]
305: c_dimension_name IN VARCHAR2)
306: is
307: SELECT /*+ ORDERED */
308: pdb.defined_balance_id
309: FROM pay_defined_balances pdb,
310: pay_balance_dimensions pbd
311: WHERE pdb.balance_type_id = c_balance_type_id
312: AND pbd.balance_dimension_id = pdb.balance_dimension_id
313: AND pbd.dimension_name = c_dimension_name;
483: is
484: SELECT DB.balance_type_id,
485: DIM.dimension_name
486: FROM pay_balance_dimensions DIM,
487: pay_defined_balances DB
488: WHERE DB.defined_balance_id = p_defined_balance_id
489: AND DIM.balance_dimension_id = DB.balance_dimension_id;
490: BEGIN
491: --
624: pay_payroll_actions ppa,
625: ff_database_items ffd,
626: ff_user_entities ffu,
627: hr_organization_information hoi,
628: pay_defined_balances pdb
629: WHERE paa.assignment_action_id=p_assignment_action_id
630: AND ppa.payroll_action_id=paa.payroll_action_id
631: AND ffd.user_name=p_item_name
632: AND ffu.user_entity_id=ffd.user_entity_id
2864: IS
2865: SELECT /*+ ORDERED */
2866: pdb.balance_type_id,
2867: pbd.dimension_name
2868: FROM pay_defined_balances pdb,
2869: pay_balance_dimensions pbd
2870: WHERE pdb.defined_balance_id = c_defined_balance_id
2871: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
2872: --
2978: IS
2979: SELECT /*+ ORDERED */
2980: pdb.balance_type_id,
2981: pbd.dimension_name
2982: FROM pay_defined_balances pdb,
2983: pay_balance_dimensions pbd
2984: WHERE pdb.defined_balance_id = c_defined_balance_id
2985: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
2986: --