eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 7275: ,pay_balance_feeds_f pbf

7271: /*+ ORDERED USE_NL(pbf, pdb, pbd, prrv) */
7272: distinct pdb.defined_balance_id
7273: from
7274: pay_input_values_f piv
7275: ,pay_balance_feeds_f pbf
7276: ,pay_defined_balances pdb
7277: ,pay_balance_dimensions pbd
7278: ,pay_run_result_values prrv
7279: where

Line 8023: pay_balance_feeds_f pbf,

8019: from
8020: pay_assignment_actions paa,
8021: pay_run_results prr,
8022: pay_input_values_f piv,
8023: pay_balance_feeds_f pbf,
8024: pay_balance_types pbt,
8025: pay_defined_balances pdb,
8026: pay_balance_dimensions pbd,
8027: pay_run_result_values prrv

Line 8069: -- pay_balance_feeds_f pbf

8065:
8066: -- and exists (select /*+ ORDERED */ ''
8067: -- from pay_run_results prr,
8068: -- pay_run_result_values prrv,
8069: -- pay_balance_feeds_f pbf
8070: -- where prr.assignment_action_id = p_asg_act_id
8071: -- and prr.run_result_id = prrv.run_result_id
8072: -- and prrv.input_value_id = pbf.input_value_id
8073: -- and pbf.balance_type_id = pbt.balance_type_id);

Line 8101: pay_balance_feeds_f pbf

8097: and exists (select /*+ ORDERED */ ''
8098: from pay_assignment_actions paa,
8099: pay_run_results prr,
8100: pay_run_result_values prrv,
8101: pay_balance_feeds_f pbf
8102: where paa.payroll_action_id = p_pact_id
8103: and prr.assignment_action_id = paa.assignment_action_id
8104: and prr.run_result_id = prrv.run_result_id
8105: and prrv.input_value_id = pbf.input_value_id

Line 8130: pay_balance_feeds_f pbf

8126: distinct pbf.balance_type_id
8127: from pay_assignment_actions paa,
8128: pay_run_results prr,
8129: pay_run_result_values prrv,
8130: pay_balance_feeds_f pbf
8131: where paa.payroll_action_id = p_pact_id
8132: and prr.assignment_action_id = paa.assignment_action_id
8133: and prr.run_result_id = prrv.run_result_id
8134: and prrv.input_value_id = pbf.input_value_id

Line 8171: pay_balance_feeds_f pbf

8167: distinct pbf.balance_type_id
8168: from pay_assignment_actions paa,
8169: pay_run_results prr,
8170: pay_run_result_values prrv,
8171: pay_balance_feeds_f pbf
8172: where paa.payroll_action_id = p_pact_id
8173: and prr.assignment_action_id = paa.assignment_action_id
8174: and prr.run_result_id = prrv.run_result_id
8175: and prrv.input_value_id = pbf.input_value_id

Line 8826: pay_balance_feeds_f pbf,

8822: pbd.balance_dimension_id
8823: from
8824: pay_run_results prr,
8825: pay_run_result_values prrv,
8826: pay_balance_feeds_f pbf,
8827: pay_balance_types pbt,
8828: pay_defined_balances pdb,
8829: pay_balance_dimensions pbd
8830: where pbd.dimension_level = 'ASG'

Line 8862: -- pay_balance_feeds_f pbf

8858: and pbt.balance_type_id = pbf.balance_type_id;
8859: -- and exists (select /*+ ORDERED */ ''
8860: -- from pay_run_results prr,
8861: -- pay_run_result_values prrv,
8862: -- pay_balance_feeds_f pbf
8863: -- where prr.assignment_action_id = p_asg_act_id
8864: -- and prr.run_result_id = prrv.run_result_id
8865: -- and prrv.input_value_id = pbf.input_value_id
8866: -- and pbf.balance_type_id = pbt.balance_type_id);

Line 8893: pay_balance_feeds_f pbf

8889: and p_def_bal_id = pba.defined_balance_id
8890: and exists (select /*+ ORDERED */ ''
8891: from pay_run_results prr,
8892: pay_run_result_values prrv,
8893: pay_balance_feeds_f pbf
8894: where prr.assignment_action_id = p_asg_act_id
8895: and prr.run_result_id = prrv.run_result_id
8896: and prrv.input_value_id = pbf.input_value_id
8897: and pdb.balance_type_id = pbf.balance_type_id

Line 8921: pay_balance_feeds_f pbf

8917: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8918: distinct pbf.balance_type_id
8919: from pay_run_results prr,
8920: pay_run_result_values prrv,
8921: pay_balance_feeds_f pbf
8922: where prr.assignment_action_id = p_asg_act_id
8923: and prr.run_result_id = prrv.run_result_id
8924: and prrv.input_value_id = pbf.input_value_id);
8925: --

Line 8960: -- pay_balance_feeds_f pbf

8956: -- (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8957: -- distinct pbf.balance_type_id
8958: -- from pay_run_results prr,
8959: -- pay_run_result_values prrv,
8960: -- pay_balance_feeds_f pbf
8961: -- where prr.assignment_action_id = p_asg_act_id
8962: -- and prr.run_result_id = prrv.run_result_id
8963: -- and prrv.input_value_id = pbf.input_value_id
8964: -- );

Line 8990: pay_balance_feeds_f pbf,

8986: pdb.balance_dimension_id
8987: from
8988: pay_run_results prr,
8989: pay_input_values_f piv,
8990: pay_balance_feeds_f pbf,
8991: pay_defined_balances pdb,
8992: pay_balance_attributes pba,
8993: pay_balance_dimensions pbd,
8994: pay_balance_validation pbv,

Line 10071: from pay_balance_feeds_f bf

10067: select 1
10068: from dual
10069: where exists (select /*+ ORDERED*/
10070: null
10071: from pay_balance_feeds_f bf
10072: , pay_run_result_values rrv
10073: where bf.balance_type_id = p_baltype_id
10074: and bf.input_value_id = rrv.input_value_id);
10075: --