DBA Data[Home] [Help]

APPS.PAY_KR_REPORT_PKG dependencies on PAY_INPUT_VALUES_F

Line 1028: from pay_input_values_f piv,

1024: cursor csr_input_value
1025: is
1026: select pet.element_type_id,
1027: piv.input_value_id
1028: from pay_input_values_f piv,
1029: pay_element_types_f pet,
1030: pay_payroll_actions ppa,
1031: pay_assignment_actions paa
1032: where paa.assignment_action_id = p_assignment_action_id

Line 1129: from pay_input_values_f piv,

1125: cursor csr_input_value
1126: is
1127: select pet.element_type_id,
1128: piv.input_value_id
1129: from pay_input_values_f piv,
1130: pay_element_types_f pet,
1131: pay_payroll_actions ppa,
1132: pay_assignment_actions paa
1133: where paa.assignment_action_id = p_assignment_action_id

Line 1230: from pay_input_values_f piv,

1226: cursor csr_input_value
1227: is
1228: select pet.element_type_id,
1229: piv.input_value_id
1230: from pay_input_values_f piv,
1231: pay_element_types_f pet,
1232: pay_payroll_actions ppa,
1233: pay_assignment_actions paa
1234: where paa.assignment_action_id = p_assignment_action_id

Line 1321: p_input_value_id in pay_input_values_f.input_value_id%type

1317: -- Bug 4442482: Added new function get_result_value
1318:
1319: function get_result_value (
1320: p_run_result_id in pay_run_results.run_result_id%type,
1321: p_input_value_id in pay_input_values_f.input_value_id%type
1322: ) return varchar2 is
1323: cursor csr_result_value is
1324: select result_value
1325: from pay_run_result_values