DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 140: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

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

Line 141: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

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

Line 142: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

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

Line 143: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

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

Line 165: p_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

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

Line 166: ,p_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

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

Line 167: ,p_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

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

Line 168: ,p_org_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

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

Line 169: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE

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

Line 171: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

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

Line 172: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE

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

Line 230: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE

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

Line 231: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE

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

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

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