eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_WEB_W4 dependencies on HR_ORGANIZATION_INFORMATION

Line 797: ln_organization_id hr_organization_information.organization_id%TYPE;

793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;
798: lr_org_info_rec hr_organization_information%ROWTYPE;
799: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
800: lv_has_errors VARCHAR2(1) := 'N';
801: lv_update_error_msg VARCHAR2(10000);

Line 798: lr_org_info_rec hr_organization_information%ROWTYPE;

794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;
798: lr_org_info_rec hr_organization_information%ROWTYPE;
799: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
800: lv_has_errors VARCHAR2(1) := 'N';
801: lv_update_error_msg VARCHAR2(10000);
802: lv_state_list VARCHAR2(10000);

Line 2827: p_context hr_organization_information.org_information_context%TYPE,

2823:
2824: End;
2825:
2826: FUNCTION get_org_context(p_person_id IN per_people_f.person_id%TYPE,
2827: p_context hr_organization_information.org_information_context%TYPE,
2828: p_level IN VARCHAR2)
2829:
2830: RETURN VARCHAR2 IS
2831:

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

2847: paf.effective_end_date
2848: and trunc(sysdate) between ppf.effective_start_date and
2849: ppf.effective_end_date;
2850:
2851: CURSOR c_org_context(ln_organization_id hr_organization_information.organization_id%TYPE) IS
2852: select nvl(hoi.ORG_INFORMATION2,'N') ORG_INFORMATION2
2853: from hr_organization_information hoi
2854: where hoi.org_information_context = p_context
2855: and hoi.organization_id = ln_organization_id;

Line 2853: from hr_organization_information hoi

2849: ppf.effective_end_date;
2850:
2851: CURSOR c_org_context(ln_organization_id hr_organization_information.organization_id%TYPE) IS
2852: select nvl(hoi.ORG_INFORMATION2,'N') ORG_INFORMATION2
2853: from hr_organization_information hoi
2854: where hoi.org_information_context = p_context
2855: and hoi.organization_id = ln_organization_id;
2856:
2857: lv_proc varchar2(80);