APPS.PAY_BALANCE_PKG dependencies on PAY_INPUT_VALUES_F

Line 6145: pay_input_values_f piv

6141: p_ele_id in number,
6142: p_effdate in date) is
6143: select prrv.result_value
6144: from pay_run_result_values prrv,
6145: pay_input_values_f piv
6146: where prrv.run_result_id = p_rr_id
6147: and piv.name = p_iv_name
6148: and piv.input_value_id = prrv.input_value_id
6149: and piv.element_type_id = p_ele_id

Line 6155: l_inp_val_name pay_input_values_f.name%type;

6151: and piv.effective_end_date;
6152: --
6153: cnt_value pay_run_result_values.result_value%type;
6154: l_rr_rec t_run_result_rec;
6155: l_inp_val_name pay_input_values_f.name%type;
6156: l_found boolean;
6157: --
6158: begin
6159: --

Line 6621: l_inp_val_name pay_input_values_f.name%type;

6617: l_eff_date date;
6618: l_asg_def_bal_id number;
6619: l_found boolean;
6620: l_asgbal_cnt number;
6621: l_inp_val_name pay_input_values_f.name%type;
6622: --
6623: BEGIN
6624: g_debug := hr_utility.debug_enabled;
6625: if g_debug then

Line 7274: pay_input_values_f piv

7270: select
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

Line 7547: l_inp_val_name pay_input_values_f.name%type;

7543: l_org_needed_chr varchar2(10);
7544: l_context_lst t_context_tab;
7545: l_cnt number;
7546: l_output_list t_detailed_bal_out_tab;
7547: l_inp_val_name pay_input_values_f.name%type;
7548: l_found boolean;
7549: --
7550: begin
7551: --

Line 8022: pay_input_values_f piv,

8018: pbd.balance_dimension_id
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,

Line 8257: l_inp_val_name pay_input_values_f.name%type;

8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8254: l_context_lst t_context_tab;
8255: l_cnt number;
8256: l_output_list t_detailed_bal_out_tab;
8257: l_inp_val_name pay_input_values_f.name%type;
8258: l_found boolean;
8259: l_next_free number;
8260: l_bg_id per_business_groups.business_group_id%type;
8261: l_leg_code per_business_groups.legislation_code%type;

Line 8989: pay_input_values_f piv,

8985: pdb.balance_type_id,
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,

Line 9098: l_inp_val_name pay_input_values_f.name%type;

9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9095: l_context_lst t_context_tab;
9096: l_cnt number;
9097: l_output_list t_detailed_bal_out_tab;
9098: l_inp_val_name pay_input_values_f.name%type;
9099: l_found boolean;
9100: l_next_free number;
9101: l_bg_id per_business_groups.business_group_id%type;
9102: l_leg_code per_business_groups.legislation_code%type;

Line 9647: l_inp_val_name pay_input_values_f.name%type;

9643: l_st2_needed_chr varchar2(10);
9644: l_context_lst t_context_tab;
9645: l_cnt number;
9646: l_output_list t_detailed_bal_out_tab;
9647: l_inp_val_name pay_input_values_f.name%type;
9648: l_found boolean;
9649: --
9650: begin
9651: --

Line 10330: l_inp_val_name pay_input_values_f.name%type;

10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;
10330: l_inp_val_name pay_input_values_f.name%type;
10331: l_asg_id number;
10332: l_pactid number;
10333: l_eff_date date;
10334: l_act_type pay_payroll_actions.action_type%type;