APPS.AP_WEB_RECEIPTS_WF dependencies on HR_ORGANIZATION_UNITS

Line 2559: l_business_group_id hr_organization_units.business_group_id%TYPE;

2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2559: l_business_group_id hr_organization_units.business_group_id%TYPE;
2560: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2561: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2562: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;
2563: l_auto_audit_id NUMBER;

Line 2727: hr_organization_units hr,

2723: select aerh.employee_id,
2724: hr.business_group_id,
2725: max(rs.audit_term_duration_days)
2726: from AP_EXPENSE_REPORT_HEADERS aerh,
2727: hr_organization_units hr,
2728: AP_AUD_RULE_SETS rs,
2729: AP_AUD_RULE_ASSIGNMENTS rsa
2730: where aerh.org_id = nvl(p_org_id, aerh.org_id)
2731: and aerh.bothpay_parent_id is null