DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 425: FROM pay_us_emp_fed_tax_rules_f ftx

421: -- Cursor to get the current FICA status
422: CURSOR csr_tax (c_effective_date IN Date
423: ,c_assignment_id IN Number) IS
424: SELECT *
425: FROM pay_us_emp_fed_tax_rules_f ftx
426: WHERE ftx.assignment_id = c_assignment_id
427: AND c_effective_date between ftx.effective_start_date
428: AND ftx.effective_end_date;
429:

Line 460: ,p_base_table_name => 'PAY_US_EMP_FED_TAX_RULES_F'

456: CLOSE csr_tax;
457:
458: Dt_Api.Find_DT_Upd_Modes
459: (p_effective_date => p_effective_date
460: ,p_base_table_name => 'PAY_US_EMP_FED_TAX_RULES_F'
461: ,p_base_key_column => 'EMP_FED_TAX_RULE_ID'
462: ,p_base_key_value => l_fed_rec.emp_fed_tax_rule_id
463: ,p_correction => l_dt_correction
464: ,p_update => l_dt_update

Line 530: FROM pay_us_emp_fed_tax_rules_f ftx

526: --Cursor to get the current FICA status
527: CURSOR csr_tax (c_effective_date IN DATE
528: ,c_assignment_id IN NUMBER) IS
529: SELECT *
530: FROM pay_us_emp_fed_tax_rules_f ftx
531: WHERE ftx.assignment_id = c_assignment_id
532: AND c_effective_date between ftx.effective_start_date
533: AND ftx.effective_end_date;
534: