DBA Data[Home] [Help]

APPS.PAY_US_TAX_API dependencies on PER_PEOPLE_F

Line 423: ln_business_group_id per_people_f.business_group_id%TYPE;

419: AS
420: l_proc VARCHAR2(80) := g_package || 'submit_fed_w4';
421: lv_trans_type VARCHAR2(30) := 'US_TAX_FORMS';
422: lv_trans_subtype VARCHAR2(30) := 'W4';
423: ln_business_group_id per_people_f.business_group_id%TYPE;
424: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
425: ln_assignment_id per_assignments_f.assignment_id%TYPE;
426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 443: from per_people_f

439: lv_update_error_msg VARCHAR2(10000);
440:
441: CURSOR c_get_bg_id(p_person_id number) IS
442: select business_group_id
443: from per_people_f
444: where person_id = p_person_id;
445:
446: CURSOR c_fed_tax_rows IS
447: select ftr.emp_fed_tax_rule_id,