APPS.PAY_ITERATE dependencies on PAY_RUN_TYPES_F_TL

Line 917: from pay_run_types_f_tl

913: --
914: cursor chk_for_tl_children
915: is
916: select 1
917: from pay_run_types_f_tl
918: where run_type_id = l_rt_id;
919: --
920: cursor get_prods(p_sess number)
921: is

Line 932: from pay_run_types_f_tl rtt

928: select l.language_code
929: from fnd_languages l
930: where l.installed_flag in ('I','B')
931: and exists (select null
932: from pay_run_types_f_tl rtt
933: where rtt.run_type_id = p_rt_id
934: and rtt.language = l.language_code);
935:
936: l_sess number;

Line 974: delete from pay_run_types_f_tl

970: -- also need to delete the tl table row, as if one exists for a partic
971: -- run_type_id it will not insert another, hence updates will not get made
972: --
973: for each_row in get_langs loop
974: delete from pay_run_types_f_tl
975: where run_type_id = p_rt_id
976: and language = each_row.language_code;
977: end loop;
978: --

Line 1226: from pay_run_types_f_tl

1222: --
1223: cursor chk_for_tl_children
1224: is
1225: select 1
1226: from pay_run_types_f_tl
1227: where run_type_id = rec_uploaded.rt_id;
1228: --
1229: l_ch_rtu_id number;
1230: l_ch_ovn number;