DBA Data[Home] [Help]

APPS.PAY_FR_RUN_TYPES dependencies on PAY_USER_COLUMNS

Line 56: , pay_user_columns puc

52: Cursor csr_row_id(c_element_name Varchar2,c_classification_name Varchar2,csr_effective_date date) Is
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'

Line 58: , pay_user_columns puc_rule_type

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'
62: and put.business_group_id is null

Line 138: ,pay_user_columns puc

134: Cursor csr_get_table_value Is
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