APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 56: WHERE eat.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id)

52: ,udt.user_table_name
53: ,udt.user_table_id
54: FROM pqp_extract_attributes eat
55: ,pay_user_tables udt
56: WHERE eat.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id)
57: AND udt.user_table_id(+) = eat.ext_user_table_id;
58: --
59: --
60: --

Line 518: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH4

514: IS
515: SELECT lea_number
516: FROM pqp_ext_cross_person_records emd
517: WHERE emd.record_type = 'M'
518: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH4
519: AND emd.request_id = g_parent_request_id ;
520: --
521: --
522: --