DBA Data[Home] [Help]

APPS.PAY_NO_SSB_CODES dependencies on PAY_RUN_RESULTS

Line 16: pay_run_results prr,

12: pxi.eei_information2 ssb_code,
13: pxi.eei_information3 add_detail
14: from
15: pay_assignment_actions paa,
16: pay_run_results prr,
17: pay_element_types_f pet,
18: pay_element_type_extra_info pxi
19: where
20: paa.assignment_action_id =p_assignment_action_id

Line 35: pay_run_results prr,

31: pxi.eei_information3 ssb_code,
32: 'AMOUNT' add_detail
33: from
34: pay_assignment_actions paa,
35: pay_run_results prr,
36: pay_element_types_f pet,
37: pay_element_type_extra_info pxi
38: where
39: paa.assignment_action_id =p_assignment_action_id

Line 183: l_run_result_id pay_run_results.run_result_id%TYPE;

179: WHERE run_result_id = p_run_result_id
180: AND input_value_id = p_input_value_id;
181:
182: l_cache_index number;
183: l_run_result_id pay_run_results.run_result_id%TYPE;
184: l_input_value_id pay_input_values_f.input_value_id%type;
185: l_value NUMBER(15):=0;
186: l_value_sum NUMBER(15):=0;
187: l_ssb_code VARCHAR2(150);