DBA Data[Home] [Help]

APPS.HR_INPUT_VALUES dependencies on PAY_INPUT_VALUES_F_TL

Line 118: from pay_input_values_f_tl ipv_tl,

114: into v_validation_check
115: from sys.dual
116: where exists
117: (select 1
118: from pay_input_values_f_tl ipv_tl,
119: pay_input_values_f ipv
120: where ipv_tl.input_value_id = ipv.input_value_id
121: and userenv('LANG') = ipv_tl.language
122: and ipv.element_type_id = p_element_type_id

Line 620: pay_input_values_f_tl ip_tl,

616: from sys.dual
617: where exists
618: (select 1
619: from pay_element_links_f el,
620: pay_input_values_f_tl ip_tl,
621: pay_input_values_f ip
622: where ip_tl.input_value_id = ip.input_value_id
623: and ip.input_value_id = p_input_value_id
624: and userenv('LANG') = ip_tl.language

Line 1145: from pay_input_values_f_tl iv_tl,

1141: -1,
1142: -1,
1143: -1,
1144: sysdate
1145: from pay_input_values_f_tl iv_tl,
1146: pay_input_values_f iv
1147: where iv_tl.input_value_id = iv.input_value_id
1148: and iv.input_value_id = iv_rec.input_value_id
1149: and userenv('LANG') = iv_tl.language