APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 3824: l_value pay_user_column_instances_f.VALUE%TYPE;

3820: )
3821: RETURN NUMBER
3822: IS
3823: l_count NUMBER := 0;
3824: l_value pay_user_column_instances_f.VALUE%TYPE;
3825: l_proc_step NUMBER(38,10):=0;
3826: l_proc_name VARCHAR2(61):=
3827: g_package_name||'pqp_gb_get_no_of_work_holidays';
3828: l_column_name pay_user_columns.user_column_name%TYPE;

Line 4242: ---- pay_user_column_instances_f uci

4238: ---- where pur.user_row_id in(
4239: ---- select distinct uci.user_row_id
4240: ---- from pay_user_tables put,
4241: ---- pay_user_columns puc,
4242: ---- pay_user_column_instances_f uci
4243: ---- where put.user_table_id = puc.user_table_id
4244: ---- and uci.user_column_id = puc.user_column_id
4245: ---- and put.user_table_name = g_udt_name
4246: ---- and puc.user_column_name = p_wp_dets.work_pattern

Line 4267: -- ,pay_user_column_instances_f uci

4263: -- WHERE pur.user_row_id IN(
4264: -- SELECT DISTINCT uci.user_row_id
4265: -- FROM pay_user_tables put
4266: -- ,pay_user_columns puc
4267: -- ,pay_user_column_instances_f uci
4268: -- ,per_business_groups_perf pbg
4269: -- WHERE put.user_table_name = g_udt_name
4270: -- AND pbg.business_group_id =
4271: -- p_wp_dets.business_group_id