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.

APPS.PAY_BALANCE_PKG dependencies on PAY_DEFINED_BALANCES

Line 105: run_def_bal_id pay_defined_balances.defined_balance_id%type,

101: (
102: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
103: priority pay_dimension_routes.priority%type,
104: route_type pay_dimension_routes.route_type%type,
105: run_def_bal_id pay_defined_balances.defined_balance_id%type,
106: retrieval_column pay_dimension_routes.retrieval_column%type
107: );
108: --
109: type t_dim_rou_tab is table of t_dim_rou_rec index by binary_integer;

Line 118: defined_balance_id pay_defined_balances.defined_balance_id%type,

114: -- Internal cache type for batch retrieval
115: --
116: type t_int_bal_rec is record
117: (
118: defined_balance_id pay_defined_balances.defined_balance_id%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: balance_type_id pay_balance_types.balance_type_id%type,
121: balance_found boolean,
122: balance_value number,

Line 145: defined_balance_id pay_defined_balances.defined_balance_id%type,

141: --
142: type t_int_rb_rec is record
143: (
144: run_balance_id pay_run_balances.run_balance_id%type,
145: defined_balance_id pay_defined_balances.defined_balance_id%type,
146: payroll_action_id pay_payroll_actions.payroll_action_id%type,
147: tax_unit_id pay_assignment_actions.tax_unit_id%type,
148: jurisdiction_code pay_run_results.jurisdiction_code%type,
149: source_id number,

Line 691: pay_defined_balances pdb

687: select context_name
688: from ff_contexts fc,
689: ff_route_context_usages frcu,
690: pay_balance_dimensions pbd,
691: pay_defined_balances pdb
692: where pdb.defined_balance_id = p_def_bal_id
693: and pdb.balance_dimension_id = pbd.balance_dimension_id
694: and pbd.route_id = frcu.route_id
695: and frcu.context_id = fc.context_id;

Line 704: , pay_defined_balances pdb -- balance defined balance

700: , pdr.route_type
701: , null run_def_bal_id
702: , pdr.retrieval_column
703: from pay_dimension_routes pdr
704: , pay_defined_balances pdb -- balance defined balance
705: where pdb.balance_dimension_id = pdr.balance_dimension_id
706: and pdb.defined_balance_id = p_def_bal_id
707: and pdr.route_type = 'RR';
708: --

Line 717: , pay_defined_balances pdb -- balance defined balance

713: , pdr.route_type
714: , rdb.defined_balance_id run_def_bal_id
715: , pdr.retrieval_column
716: from pay_dimension_routes pdr
717: , pay_defined_balances pdb -- balance defined balance
718: , pay_defined_balances rdb -- run defined balance
719: where pdb.balance_dimension_id = pdr.balance_dimension_id
720: and pdb.defined_balance_id = p_def_bal_id
721: and rdb.balance_type_id = pdb.balance_type_id

Line 718: , pay_defined_balances rdb -- run defined balance

714: , rdb.defined_balance_id run_def_bal_id
715: , pdr.retrieval_column
716: from pay_dimension_routes pdr
717: , pay_defined_balances pdb -- balance defined balance
718: , pay_defined_balances rdb -- run defined balance
719: where pdb.balance_dimension_id = pdr.balance_dimension_id
720: and pdb.defined_balance_id = p_def_bal_id
721: and rdb.balance_type_id = pdb.balance_type_id
722: and rdb.balance_dimension_id = pdr.run_dimension_id

Line 756: , pay_defined_balances DEF

752: g_defbal_cache(p_defined_balance_id).balance_type_id,
753: g_defbal_cache(p_defined_balance_id).dimension_lvl,
754: g_defbal_cache(p_defined_balance_id).period_type
755: from pay_balance_dimensions DIM
756: , pay_defined_balances DEF
757: , pay_balance_types TYP
758: where DIM.balance_dimension_id = DEF.balance_dimension_id
759: and TYP.balance_type_id = DEF.balance_type_id
760: and DEF.defined_balance_id = p_defined_balance_id;

Line 772: , pay_defined_balances pdb

768: into g_defbal_cache(p_defined_balance_id).balance_type_column,
769: g_defbal_cache(p_defined_balance_id).decode_required,
770: g_defbal_cache(p_defined_balance_id).dim_rou_rr_route_id
771: from pay_dimension_routes pdr
772: , pay_defined_balances pdb
773: where pdb.balance_dimension_id = pdr.balance_dimension_id
774: and pdb.defined_balance_id = p_defined_balance_id
775: and pdr.route_type = 'RR';
776: --

Line 2783: l_balance_type_id pay_defined_balances.balance_type_id%type;

2779: l_user_name ff_user_entities.user_entity_name%type;
2780: l_business_group_id ff_user_entities.business_group_id%type;
2781: l_legislation_code ff_user_entities.legislation_code%type;
2782: l_balance_list t_batch_list;
2783: l_balance_type_id pay_defined_balances.balance_type_id%type;
2784: l_route_id pay_dimension_routes.route_id%type;
2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;
2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;
2787: l_decode_required boolean;

Line 2813: from pay_defined_balances pdb,

2809: l_balance_type_column,
2810: l_retrieval_column,
2811: l_decode_required_chr,
2812: l_jur_lvl
2813: from pay_defined_balances pdb,
2814: pay_dimension_routes pdr,
2815: pay_balance_types pbt
2816: where pdb.defined_balance_id = p_def_bal_id
2817: and pdb.balance_dimension_id = pdr.balance_dimension_id

Line 2997: pay_defined_balances pdb

2993: pbd.start_date_code
2994: into l_period_type,
2995: l_start_date_code
2996: from pay_balance_dimensions pbd,
2997: pay_defined_balances pdb
2998: where pdb.defined_balance_id = p_retreival_db_id
2999: and pdb.balance_dimension_id = pbd.balance_dimension_id;
3000:
3001: --

Line 3059: , pay_defined_balances pdb -- balance defined balance

3055: , pdr.priority
3056: , pdr.route_type
3057: , rdb.defined_balance_id run_def_bal_id
3058: from pay_dimension_routes pdr
3059: , pay_defined_balances pdb -- balance defined balance
3060: , pay_defined_balances rdb -- run defined balance
3061: where pdb.balance_dimension_id = pdr.balance_dimension_id
3062: and pdb.defined_balance_id = p_def_bal_id
3063: and rdb.balance_type_id = pdb.balance_type_id

Line 3060: , pay_defined_balances rdb -- run defined balance

3056: , pdr.route_type
3057: , rdb.defined_balance_id run_def_bal_id
3058: from pay_dimension_routes pdr
3059: , pay_defined_balances pdb -- balance defined balance
3060: , pay_defined_balances rdb -- run defined balance
3061: where pdb.balance_dimension_id = pdr.balance_dimension_id
3062: and pdb.defined_balance_id = p_def_bal_id
3063: and rdb.balance_type_id = pdb.balance_type_id
3064: and rdb.balance_dimension_id = pdr.run_dimension_id

Line 3069: l_valid pay_defined_balances.run_balance_status%type;

3065: and pdr.route_type = 'SRB'
3066: order by 2;
3067: --
3068: l_balval_found boolean;
3069: l_valid pay_defined_balances.run_balance_status%type;
3070: l_balance_value number;
3071: l_defbal_rec t_def_bal_rec;
3072: l_position number;
3073: --

Line 5937: from pay_defined_balances pdb,

5933: cursor get_def_bals(p_bal_id number,
5934: p_iv_id number)
5935: is
5936: select pdb.defined_balance_id
5937: from pay_defined_balances pdb,
5938: pay_balance_validation pbv
5939: where pdb.balance_type_id = p_bal_id
5940: and pdb.save_run_balance = 'Y'
5941: and pbv.defined_balance_id = pdb.defined_balance_id

Line 6013: from pay_defined_balances pdb

6009: --
6010: cursor get_def_bals(p_bal_id number)
6011: is
6012: select pdb.defined_balance_id
6013: from pay_defined_balances pdb
6014: where pdb.balance_type_id = p_bal_id
6015: and pdb.save_run_balance = 'Y';
6016: --
6017: BEGIN

Line 6666: from pay_defined_balances pdb,

6662: --
6663: -- Now maintain the assignment ones
6664: select pdb.defined_balance_id
6665: into g_rlb_asg_defbals(l_cnt).defined_balance_id
6666: from pay_defined_balances pdb,
6667: pay_defined_balances pdb_grp,
6668: pay_balance_dimensions pbd
6669: where pdb_grp.defined_balance_id = g_rlb_grp_defbals(l_cnt).defined_balance_id
6670: and pdb_grp.balance_dimension_id = pbd.balance_dimension_id

Line 6667: pay_defined_balances pdb_grp,

6663: -- Now maintain the assignment ones
6664: select pdb.defined_balance_id
6665: into g_rlb_asg_defbals(l_cnt).defined_balance_id
6666: from pay_defined_balances pdb,
6667: pay_defined_balances pdb_grp,
6668: pay_balance_dimensions pbd
6669: where pdb_grp.defined_balance_id = g_rlb_grp_defbals(l_cnt).defined_balance_id
6670: and pdb_grp.balance_dimension_id = pbd.balance_dimension_id
6671: and pdb.balance_type_id = pdb_grp.balance_type_id

Line 7276: ,pay_defined_balances pdb

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
7280: pbd.dimension_level = 'ASG'

Line 8025: pay_defined_balances pdb,

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
8028: where pbd.dimension_level = 'GRP'
8029: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'

Line 8088: pay_defined_balances pdb,

8084: pdb.balance_dimension_id
8085: from
8086: pay_bal_attribute_definitions pbad,
8087: pay_balance_attributes pba,
8088: pay_defined_balances pdb,
8089: pay_balance_dimensions pbd
8090: where
8091: pbad.attribute_name = p_bal_list
8092: and pbad.attribute_id = pba.attribute_id

Line 8115: pay_defined_balances pdb,

8111: pdb.balance_dimension_id
8112: from
8113: pay_bal_attribute_definitions pbad,
8114: pay_balance_attributes pba,
8115: pay_defined_balances pdb,
8116: pay_balance_dimensions pbd
8117: where
8118: pbad.attribute_name = p_bal_list
8119: and pbad.attribute_id = pba.attribute_id

Line 8150: pay_defined_balances pdb,

8146: pdb.balance_dimension_id
8147: from
8148: pay_bal_attribute_definitions pbad,
8149: pay_balance_attributes pba,
8150: pay_defined_balances pdb,
8151: pay_balance_dimensions pbd
8152: where
8153: pbad.attribute_name = p_bal_list
8154: and pbad.attribute_id = pba.attribute_id

Line 8828: pay_defined_balances pdb,

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'
8831: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'
8832: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 8880: pay_defined_balances pdb,

8876: pdb.balance_dimension_id
8877: from
8878: pay_bal_attribute_definitions pbad,
8879: pay_balance_attributes pba,
8880: pay_defined_balances pdb,
8881: pay_balance_dimensions pbd
8882:
8883: where
8884: pbad.attribute_name = p_bal_list

Line 8907: pay_defined_balances pdb,

8903: pdb.balance_dimension_id
8904: from
8905: pay_bal_attribute_definitions pbad,
8906: pay_balance_attributes pba,
8907: pay_defined_balances pdb,
8908: pay_balance_dimensions pbd
8909: where
8910: pbad.attribute_name = p_bal_list
8911: and pbad.attribute_id = pba.attribute_id

Line 8940: -- pay_defined_balances pdb,

8936: -- pdb.balance_dimension_id
8937: -- from
8938: -- pay_bal_attribute_definitions pbad,
8939: -- pay_balance_attributes pba,
8940: -- pay_defined_balances pdb,
8941: -- pay_balance_dimensions pbd
8942: -- where
8943: -- pbad.attribute_name = p_bal_list
8944: -- and pbad.attribute_id = pba.attribute_id

Line 8991: pay_defined_balances pdb,

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,
8995: pay_run_result_values prrv

Line 9410: from pay_defined_balances pdb,

9406: --
9407: cursor crs_asgact (p_asg_act_id number)
9408: is
9409: select pdb.defined_balance_id
9410: from pay_defined_balances pdb,
9411: pay_balance_dimensions pbd,
9412: pay_assignment_actions paa,
9413: pay_payroll_actions ppa,
9414: per_business_groups_perf pbg

Line 9439: pay_defined_balances pdb,

9435: from pay_assignment_actions paa,
9436: pay_payroll_actions ppa,
9437: per_business_groups_perf pbg,
9438: pay_balance_validation pbv,
9439: pay_defined_balances pdb,
9440: pay_balance_dimensions pbd
9441: where pbd.dimension_level = 'ASG'
9442: and pdb.save_run_balance = 'Y'
9443: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 9861: from pay_defined_balances pdb,

9857: --
9858: cursor crs_pact (p_pact_id number)
9859: is
9860: select pdb.defined_balance_id
9861: from pay_defined_balances pdb,
9862: pay_balance_dimensions pbd,
9863: pay_payroll_actions ppa,
9864: per_business_groups_perf pbg
9865: where pbd.dimension_level = 'GRP'

Line 9887: pay_defined_balances pdb,

9883: pdb.defined_balance_id
9884: from pay_payroll_actions ppa,
9885: per_business_groups_perf pbg,
9886: pay_balance_validation pbv,
9887: pay_defined_balances pdb,
9888: pay_balance_dimensions pbd
9889: where pbd.dimension_level = 'GRP'
9890: and pdb.save_run_balance = 'Y'
9891: and pdb.balance_dimension_id = pbd.balance_dimension_id