APPS.PAY_US_WEB_W4 dependencies on HR_ORGANIZATION_INFORMATION

Line 929: ln_organization_id hr_organization_information.organization_id%TYPE;

925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;
930: lr_org_info_rec hr_organization_information%ROWTYPE;
931: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
932: lv_has_errors VARCHAR2(1) := 'N';
933: lv_update_error_msg VARCHAR2(10000);

Line 930: lr_org_info_rec hr_organization_information%ROWTYPE;

926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;
930: lr_org_info_rec hr_organization_information%ROWTYPE;
931: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
932: lv_has_errors VARCHAR2(1) := 'N';
933: lv_update_error_msg VARCHAR2(10000);
934: lv_state_list VARCHAR2(10000);

Line 3008: p_context hr_organization_information.org_information_context%TYPE,

3004:
3005: End;
3006:
3007: FUNCTION get_org_context(p_person_id IN per_people_f.person_id%TYPE,
3008: p_context hr_organization_information.org_information_context%TYPE,
3009: p_level IN VARCHAR2)
3010:
3011: RETURN VARCHAR2 IS
3012:

Line 3032: CURSOR c_org_context(ln_organization_id hr_organization_information.organization_id%TYPE) IS

3028: paf.effective_end_date
3029: and trunc(sysdate) between ppf.effective_start_date and
3030: ppf.effective_end_date;
3031:
3032: CURSOR c_org_context(ln_organization_id hr_organization_information.organization_id%TYPE) IS
3033: select nvl(hoi.ORG_INFORMATION2,'N') ORG_INFORMATION2
3034: from hr_organization_information hoi
3035: where hoi.org_information_context = p_context
3036: and hoi.organization_id = ln_organization_id;

Line 3034: from hr_organization_information hoi

3030: ppf.effective_end_date;
3031:
3032: CURSOR c_org_context(ln_organization_id hr_organization_information.organization_id%TYPE) IS
3033: select nvl(hoi.ORG_INFORMATION2,'N') ORG_INFORMATION2
3034: from hr_organization_information hoi
3035: where hoi.org_information_context = p_context
3036: and hoi.organization_id = ln_organization_id;
3037:
3038: lv_proc varchar2(80);