DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_USER_ROWS_F

Line 534: FROM PAY_USER_ROWS_F pur

530: CURSOR csr_get_table_range(c_value NUMBER
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)

Line 1848: FROM pay_user_rows_f pur

1844: --
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'