DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_RUN_RESULTS

Line 125: pay_run_results prr,

121: CURSOR cur_spl_rate(lp_assignment_action_id NUMBER,
122: lp_element_name VARCHAR2,lp_input_value_name VARCHAR2) IS
123: select prrv.result_value
124: from pay_run_result_values prrv,
125: pay_run_results prr,
126: pay_element_types_f pet,
127: pay_input_values_f piv,
128: pay_assignment_actions paa,
129: pay_payroll_actions ppa

Line 303: , pay_run_results rr

299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
302: from pay_assignment_actions aa
303: , pay_run_results rr
304: , pay_run_result_values rrv
305: , pay_input_values_f iv
306: , pay_input_values_f_tl ivtl
307: , pay_element_types_f et

Line 508: pay_run_results rr

504: ,rr.run_result_id)
505: ,null) source_text2
506: from pay_assignment_actions aa,
507: pay_payroll_actions pa,
508: pay_run_results rr
509: where aa.ASSIGNMENT_ID = l_assignment_id
510: and aa.assignment_action_id = rr.assignment_action_id
511: and l_action_sequence >= aa.action_sequence
512: and aa.payroll_action_id = pa.payroll_action_id