DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_USER_ROWS_F

Line 2218: pay_user_rows_f pur

2214: cursor c_get_seq_num_range(cp_run_year varchar2) is
2215: select ROW_LOW_RANGE_OR_NAME range_start,
2216: ROW_HIGH_RANGE range_end
2217: from pay_user_tables put,
2218: pay_user_rows_f pur
2219: where pur.USER_TABLE_ID=put.USER_TABLE_ID
2220: and put.USER_TABLE_NAME = 'RL1 PDF Sequence Range'
2221: and fnd_date.string_to_date('31/12/'||cp_run_year,'DD/MM/YYYY')
2222: between pur.EFFECTIVE_START_DATE and pur.EFFECTIVE_END_DATE;