APPS.PER_CAGR_UTILITY_PKG dependencies on PER_CAGR_REQUESTS

Line 238: from per_cagr_requests cr

234: l_effective_date DATE := NULL;
235:
236: CURSOR csr_requests IS
237: select max(cr.cagr_request_id)
238: from per_cagr_requests cr
239: where cr.assignment_id = p_assignment_id
240: and cr.process_date = (select max(cr1.process_date)
241: from per_cagr_requests cr1
242: where cr1.assignment_id = p_assignment_id

Line 241: from per_cagr_requests cr1

237: select max(cr.cagr_request_id)
238: from per_cagr_requests cr
239: where cr.assignment_id = p_assignment_id
240: and cr.process_date = (select max(cr1.process_date)
241: from per_cagr_requests cr1
242: where cr1.assignment_id = p_assignment_id
243: and l_effective_date >= cr1.process_date);
244:
245: l_proc VARCHAR2(72) := g_pkg||'get_cagr_request_id';

Line 782: insert into per_cagr_requests (cagr_request_id

778: --
779: pragma autonomous_transaction;
780:
781: BEGIN
782: insert into per_cagr_requests (cagr_request_id
783: ,process_date
784: ,operation_mode
785: ,business_group_id
786: ,assignment_id

Line 796: values (PER_CAGR_REQUESTS_S.nextval

792: ,cagr_entitlement_item_id
793: ,parent_request_id
794: ,commit_flag
795: ,denormalise_flag)
796: values (PER_CAGR_REQUESTS_S.nextval
797: ,trunc(p_process_date)
798: ,p_operation_mode
799: ,p_business_group_id
800: ,p_assignment_id

Line 953: AND exists (select 'X' from per_cagr_requests req

949: SELECT text
950: FROM per_cagr_log
951: WHERE cagr_request_id = p_cagr_request_id
952: AND priority <= l_level
953: AND exists (select 'X' from per_cagr_requests req
954: where req.cagr_request_id = p_cagr_request_id
955: and req.operation_mode = 'SA')
956: ORDER BY log_id;
957: