APPS.PAY_FR_RUN_TYPES dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 57: , pay_user_column_instances_f puci

53: select pur.row_low_range_or_name row_id,puci.value
54: from pay_user_tables put
55: , pay_user_rows_f pur
56: , pay_user_columns puc
57: , pay_user_column_instances_f puci
58: , pay_user_columns puc_rule_type
59: , pay_user_column_instances_f puci_rule_type
60: where put.user_table_name = 'FR_RUN_TYPE_RULES'
61: and put.legislation_code = 'FR'

Line 59: , pay_user_column_instances_f puci_rule_type

55: , pay_user_rows_f pur
56: , pay_user_columns puc
57: , pay_user_column_instances_f puci
58: , pay_user_columns puc_rule_type
59: , pay_user_column_instances_f puci_rule_type
60: where put.user_table_name = 'FR_RUN_TYPE_RULES'
61: and put.legislation_code = 'FR'
62: and put.business_group_id is null
63: and puc.user_table_id = put.user_table_id

Line 132: l_value pay_user_column_instances_f.value%TYPE;

128: p_row_value in varchar2,
129: p_effective_date in date )
130: Return varchar2 is
131:
132: l_value pay_user_column_instances_f.value%TYPE;
133:
134: Cursor csr_get_table_value Is
135: Select puci.value
136: From pay_user_tables put

Line 139: ,pay_user_column_instances_f puci

135: Select puci.value
136: From pay_user_tables put
137: ,pay_user_rows_f pur
138: ,pay_user_columns puc
139: ,pay_user_column_instances_f puci
140: Where put.user_table_name = p_table_name
141: and put.legislation_code = 'FR'
142: and put.business_group_id Is Null
143: and put.user_table_id = pur.user_table_id