APPS.PQP_SCHEDULE_CALCULATION_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 248: pay_user_column_instances_f uci

244: WHERE pur.user_row_id IN
245: (SELECT DISTINCT uci.user_row_id
246: FROM pay_user_tables put,
247: pay_user_columns puc,
248: pay_user_column_instances_f uci
249: WHERE put.user_table_name = g_udt_name
250: AND put.legislation_code = g_legislation_code -- Added on 02/01/2003
251: AND puc.user_table_id = put.user_table_id
252: AND puc.user_column_name = p_wp_dets.work_pattern

Line 1535: l_value pay_user_column_instances_f.value%TYPE ;

1531: ,p_override_wp IN VARCHAR2
1532: ) RETURN NUMBER
1533: IS
1534: l_retval number ;
1535: l_value pay_user_column_instances_f.value%TYPE ;
1536: l_error_message fnd_new_messages.message_text%TYPE ;
1537: l_proc_name VARCHAR2(61) := g_package_name||'get_working_days_in_week';
1538: l_proc_step NUMBER(20,10) ;
1539: l_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

Line 1836: FROM pay_user_column_instances_f uci

1832: SELECT uci.user_row_id
1833: ,uci.value hours_in_text
1834: ,uci.effective_start_date
1835: ,uci.effective_end_date
1836: FROM pay_user_column_instances_f uci
1837: WHERE uci.user_column_id = p_user_column_id -- represents the work pattern
1838: AND p_effective_date
1839: BETWEEN uci.effective_start_date
1840: AND uci.effective_end_date