[Home] [Help]
77: ------------------------------------------------------------
78: select 'Y'
79: into l_is_notif_rule_setup
80: from AP_AUD_RULE_SETS rs,
81: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
82: where rsa.org_id = p_org_id
83: and rsa.rule_set_id = rs.rule_set_id
84: and rs.rule_set_type = C_NOTIFY_RULE
85: and TRUNC(p_report_submitted_date)
2598: rs.NOTIFY_RCT_OVERDUE_DAYS,
2599: rs.NOTIFY_IMG_RCT_OVERDUE_DAYS
2600: from AP_EXPENSE_REPORT_HEADERS aerh,
2601: AP_AUD_RULE_SETS rs,
2602: AP_AUD_RULE_ASSIGNMENTS rsa
2603: where (aerh.receipts_status in (C_REQUIRED, C_MISSING)
2604: OR decode(aerh.image_receipts_status, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.image_receipts_status) in (C_REQUIRED, C_MISSING))
2605: and aerh.bothpay_parent_id is null
2606: and aerh.shortpay_parent_id is null
2662: aerh.receipts_status,
2663: 'ORIGINAL'
2664: from AP_EXPENSE_REPORT_HEADERS aerh,
2665: AP_AUD_RULE_SETS rs,
2666: AP_AUD_RULE_ASSIGNMENTS rsa
2667: where aerh.receipts_status in (C_REQUIRED, C_MISSING)
2668: and aerh.bothpay_parent_id is null
2669: and rsa.org_id = nvl(p_org_id, rsa.org_id)
2670: and rsa.org_id = aerh.org_id
2690: aerh.image_receipts_status,
2691: 'IMAGE'
2692: from AP_EXPENSE_REPORT_HEADERS aerh,
2693: AP_AUD_RULE_SETS rs,
2694: AP_AUD_RULE_ASSIGNMENTS rsa
2695: where aerh.image_receipts_status in (C_REQUIRED, C_MISSING)
2696: and aerh.bothpay_parent_id is null
2697: and rsa.org_id = nvl(p_org_id, rsa.org_id)
2698: and rsa.org_id = aerh.org_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
2732: and aerh.report_submitted_date is not null
2733: and hr.organization_id = aerh.org_id