DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_USER_TABLES

Line 535: ,PAY_USER_TABLES put

531: ,c_effective_date DATE) IS
532: SELECT to_number(pur.ROW_LOW_RANGE_OR_NAME) Low_value
533: ,to_number(pur.ROW_HIGH_RANGE) High_value
534: FROM PAY_USER_ROWS_F pur
535: ,PAY_USER_TABLES put
536: WHERE put.USER_TABLE_NAME = 'ES_WORK_RELATED_EARNINGS_DEDUCTION'
537: AND put.USER_TABLE_ID = pur.USER_TABLE_ID
538: AND c_value between to_number(pur.ROW_LOW_RANGE_OR_NAME) AND to_number(pur.ROW_HIGH_RANGE)
539: AND c_effective_date between pur.effective_start_date AND pur.effective_end_date;

Line 1849: ,pay_user_tables put

1845: CURSOR c_get_rows(c_efective_date DATE) IS
1846: SELECT to_number(pur.row_low_range_or_name) Low_val
1847: ,to_number(pur.ROW_HIGH_RANGE) high_val
1848: FROM pay_user_rows_f pur
1849: ,pay_user_tables put
1850: WHERE put.legislation_code = 'ES'
1851: AND pur.user_table_id = put.user_table_id
1852: AND put.user_table_name like 'ES_WITHHOLDING_QUOTAS'
1853: AND c_efective_date BETWEEN pur.effective_start_date AND pur.effective_end_date