DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 143: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

139: **
140: ******************************************************************/
141:
142: PROCEDURE update_alien_tax_records(
143: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
144: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
145: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
146: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
147: ,p_process VARCHAR2

Line 144: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

140: ******************************************************************/
141:
142: PROCEDURE update_alien_tax_records(
143: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
144: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
145: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
146: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
147: ,p_process VARCHAR2
148: ,p_itemtype VARCHAR2

Line 145: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

141:
142: PROCEDURE update_alien_tax_records(
143: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
144: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
145: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
146: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
147: ,p_process VARCHAR2
148: ,p_itemtype VARCHAR2
149: ,p_person_id per_people_f.person_id%TYPE default null

Line 146: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

142: PROCEDURE update_alien_tax_records(
143: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
144: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
145: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
146: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
147: ,p_process VARCHAR2
148: ,p_itemtype VARCHAR2
149: ,p_person_id per_people_f.person_id%TYPE default null
150: ,p_effective_date date default null

Line 168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

164: ******************************************************************/
165:
166:
167: PROCEDURE update_tax_records(
168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

Line 169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

165:
166:
167: PROCEDURE update_tax_records(
168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'

Line 170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

166:
167: PROCEDURE update_tax_records(
168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

167: PROCEDURE update_tax_records(
168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
175: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

Line 172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

168: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
169: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
175: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
176: ,p_transaction_id hr_api_transactions.transaction_id%type

Line 174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

170: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
175: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
176: ,p_transaction_id hr_api_transactions.transaction_id%type
177: ,p_person_id VARCHAR2
178: ,p_transaction_type VARCHAR2

Line 175: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

171: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
172: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
173: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
174: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
175: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
176: ,p_transaction_id hr_api_transactions.transaction_id%type
177: ,p_person_id VARCHAR2
178: ,p_transaction_type VARCHAR2
179: ,p_source_name VARCHAR2

Line 233: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

229: --
230: FUNCTION Fed_State_Filing_Status_Match(
231: p_state_code IN pay_us_states.state_code%TYPE
232: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
233: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
234: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
235: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
236: ,p_fed_exmpt_cnt IN NUMBER
237: ,p_state_empt_cnt IN NUMBER

Line 234: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

230: FUNCTION Fed_State_Filing_Status_Match(
231: p_state_code IN pay_us_states.state_code%TYPE
232: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
233: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
234: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
235: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
236: ,p_fed_exmpt_cnt IN NUMBER
237: ,p_state_empt_cnt IN NUMBER
238: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

Line 238: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

234: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
235: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE
236: ,p_fed_exmpt_cnt IN NUMBER
237: ,p_state_empt_cnt IN NUMBER
238: ,p_new_filing_status_code IN OUT NOCOPY pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
239: )
240: RETURN BOOLEAN;
241: --
242: --