APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_CUSTOMER_DETAILS

Line 1833: FROM ozf_sd_customer_details

1829:
1830:
1831: CURSOR c_request_customer_id(p_request_customer_id IN NUMBER,p_request_header_id IN NUMBER)IS
1832: SELECT request_customer_id
1833: FROM ozf_sd_customer_details
1834: WHERE request_customer_id = p_request_customer_id
1835: AND request_header_id = p_request_header_id ;
1836:
1837: CURSOR c_party_id(p_party_id IN NUMBER)IS

Line 1889: FROM ozf_sd_customer_details

1885: attribute13,
1886: attribute14,
1887: attribute15,
1888: end_customer_flag
1889: FROM ozf_sd_customer_details
1890: WHERE request_customer_id = p_request_customer_id;
1891:
1892: BEGIN
1893:

Line 2558: SELECT OZF_SD_CUSTOMER_DETAILS_S.nextval

2554: l_request_cust_seq NUMBER;
2555: l_cust_count NUMBER;
2556:
2557: CURSOR c_reqest_cust_seq IS
2558: SELECT OZF_SD_CUSTOMER_DETAILS_S.nextval
2559: FROM dual;
2560:
2561: CURSOR c_cust_details(p_request_header_id IN NUMBER
2562: ,p_cust_usage_code IN VARCHAR2

Line 2567: FROM ozf_sd_customer_details

2563: ,p_party_id IN NUMBER
2564: ,p_cust_account_id IN NUMBER
2565: ,p_end_customer_flag IN VARCHAR2)IS
2566: SELECT COUNT(1)
2567: FROM ozf_sd_customer_details
2568: WHERE request_header_id = p_request_header_id
2569: AND cust_usage_code = p_cust_usage_code
2570: AND party_id = p_party_id
2571: AND cust_account_id = p_cust_account_id

Line 4539: FROM ozf_sd_customer_details

4535: WHERE request_header_id = p_request_header_id;
4536:
4537: CURSOR c_cust_flag_check(p_request_header_id IN NUMBER,p_end_customer_flag IN VARCHAR2)IS
4538: SELECT COUNT(1)
4539: FROM ozf_sd_customer_details
4540: WHERE request_header_id = p_request_header_id
4541: AND end_customer_flag = p_end_customer_flag;
4542:
4543: CURSOR c_source_customer_dtl(p_request_header_id IN NUMBER,p_end_customer_flag IN VARCHAR2)IS

Line 4566: FROM ozf_sd_customer_details

4562: attribute13,
4563: attribute14,
4564: attribute15,
4565: end_customer_flag
4566: FROM ozf_sd_customer_details
4567: WHERE request_header_id = p_request_header_id
4568: AND end_customer_flag = p_end_customer_flag;
4569:
4570: CURSOR c_authorization_period(p_supplier_id IN NUMBER,