APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 40: from pay_user_column_instances_f puci

36: l_future_row_exists number;
37: cursor csr_check_future_rows (c_user_column_instance_id number, c_effective_date date)
38: is
39: select 1
40: from pay_user_column_instances_f puci
41: where user_column_instance_id = c_user_column_instance_id
42: and c_effective_date between effective_start_date and effective_end_date
43: and exists( select null
44: from pay_user_column_instances_f pui

Line 44: from pay_user_column_instances_f pui

40: from pay_user_column_instances_f puci
41: where user_column_instance_id = c_user_column_instance_id
42: and c_effective_date between effective_start_date and effective_end_date
43: and exists( select null
44: from pay_user_column_instances_f pui
45: where pui.user_column_instance_id = puci.user_column_instance_id
46: and pui.effective_start_date > puci.effective_end_date
47: );
48:

Line 129: from pay_user_column_instances_f

125:
126: cursor csr_get_user_column_insta_id(c_user_row_id number,c_user_column_id number,c_effective_date date)
127: is
128: select user_column_instance_id,effective_start_date,business_group_id,legislation_code
129: from pay_user_column_instances_f
130: where user_row_id = c_user_row_id
131: and user_column_id = c_user_column_id
132: and c_effective_date between effective_start_date and effective_end_date;
133:

Line 958: from pay_user_column_instances_f pui,

954: l_user_row_user_key := 'PAY_USER_ROW:'|| p_user_table_name || ':' || l_business_group_name || '#'
955: || p_row_low_range_or_name;
956:
957: l_statement := '(select puc.user_column_name || '':'' || pui.value qualified_value
958: from pay_user_column_instances_f pui,
959: pay_user_columns puc,
960: pay_user_rows_f pur
961: where pur.row_low_range_or_name = :1
962: and pur.user_table_id = :2