DBA Data[Home] [Help]

APPS.AP_WEB_RECEIPTS_WF dependencies on HR_ORGANIZATION_UNITS

Line 2199: l_business_group_id hr_organization_units.business_group_id%TYPE;

2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2199: l_business_group_id hr_organization_units.business_group_id%TYPE;
2200: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2201: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2202: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;
2203: l_auto_audit_id NUMBER;

Line 2259: hr_organization_units hr,

2255: select aerh.employee_id,
2256: hr.business_group_id,
2257: max(rs.audit_term_duration_days)
2258: from AP_EXPENSE_REPORT_HEADERS aerh,
2259: hr_organization_units hr,
2260: AP_AUD_RULE_SETS rs,
2261: AP_AUD_RULE_ASSIGNMENTS rsa
2262: where aerh.org_id = nvl(p_org_id, aerh.org_id)
2263: and aerh.bothpay_parent_id is null