APPS.OKL_SSC_WF dependencies on OKC_K_HEADERS_ALL_B

Line 1901: l_org_info okc_k_headers_all_b.org_id%type;

1897: l_requestor_id NUMBER;
1898: l_approver_id NUMBER;
1899: l_resp_key VARCHAR2(30);
1900: l_respString VARCHAR2(15) := 'FND_RESP540:';
1901: l_org_info okc_k_headers_all_b.org_id%type;
1902: CURSOR contract_cur(l_chr_id NUMBER)
1903: IS
1904: SELECT CONTRACT_NUMBER ,org_id
1905: FROM OKC_K_HEADERS_all_b --modified by rajnisku for getting org_id

Line 1905: FROM OKC_K_HEADERS_all_b --modified by rajnisku for getting org_id

1901: l_org_info okc_k_headers_all_b.org_id%type;
1902: CURSOR contract_cur(l_chr_id NUMBER)
1903: IS
1904: SELECT CONTRACT_NUMBER ,org_id
1905: FROM OKC_K_HEADERS_all_b --modified by rajnisku for getting org_id
1906: WHERE id = l_chr_id;
1907:
1908: CURSOR user_info(l_user_id NUMBER) IS
1909: SELECT user_name from fnd_user

Line 2034: select org_id from okc_k_headers_all_b

2030: AND rg.rgd_code ='LABILL'
2031: AND rl.rule_information_category = 'LAINVD'
2032: AND rg.dnz_chr_id = p_chr_id;
2033: CURSOR org_info(p_contract_id NUMBER) IS --added by rajnisku for retrieving orginfo
2034: select org_id from okc_k_headers_all_b
2035: where id=p_contract_id;
2036: l_org_info okc_k_headers_all_b.org_id%type;
2037: rule_id_rec rule_id_cur%ROWTYPE;
2038: l_rule_id NUMBER;

Line 2036: l_org_info okc_k_headers_all_b.org_id%type;

2032: AND rg.dnz_chr_id = p_chr_id;
2033: CURSOR org_info(p_contract_id NUMBER) IS --added by rajnisku for retrieving orginfo
2034: select org_id from okc_k_headers_all_b
2035: where id=p_contract_id;
2036: l_org_info okc_k_headers_all_b.org_id%type;
2037: rule_id_rec rule_id_cur%ROWTYPE;
2038: l_rule_id NUMBER;
2039: l_rgp_id NUMBER;
2040: l_contract_id NUMBER;

Line 2122: select org_id from okc_k_headers_all_b

2118: actid in number,
2119: funcmode in varchar2,
2120: resultout out nocopy varchar2 ) is
2121: CURSOR org_info(p_contract_id NUMBER) IS
2122: select org_id from okc_k_headers_all_b
2123: where id=p_contract_id; --added by rajnisku for retrieving orginfo
2124: l_org_info okc_k_headers_all_b.org_id%type;
2125:
2126: --rkuttiya commented the below cursor for bug #6523600

Line 2124: l_org_info okc_k_headers_all_b.org_id%type;

2120: resultout out nocopy varchar2 ) is
2121: CURSOR org_info(p_contract_id NUMBER) IS
2122: select org_id from okc_k_headers_all_b
2123: where id=p_contract_id; --added by rajnisku for retrieving orginfo
2124: l_org_info okc_k_headers_all_b.org_id%type;
2125:
2126: --rkuttiya commented the below cursor for bug #6523600
2127: /*CURSOR current_billing_info(p_contract_id NUMBER) IS
2128: SELECT contract.contract_number contract_number,

Line 2132: okc_k_headers_all_b contract

2128: SELECT contract.contract_number contract_number,
2129: site.name bill_to_site,
2130: site.description bill_to_address
2131: FROM okx_cust_site_uses_v site ,
2132: okc_k_headers_all_b contract
2133: WHERE contract.id = p_contract_id
2134: AND site.id1 = contract.bill_to_site_use_id; */
2135:
2136: --rkuttiya added the below cursor for bug#6523600

Line 2147: okc_k_headers_all_b contract

2143: FROM hz_cust_site_uses_all cs,
2144: hz_cust_acct_sites_all ca,
2145: hz_party_sites ps,
2146: hz_locations l,
2147: okc_k_headers_all_b contract
2148: WHERE cs.cust_acct_site_id = ca.cust_acct_site_id
2149: AND ca.party_site_id = ps.party_site_id
2150: AND ps.location_id = l.location_id
2151: AND l.content_source_type = 'USER_ENTERED'

Line 2466: from okc_k_headers_all_b

2462: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
2463:
2464: CURSOR c_get_khr_org(p_contract_id IN NUMBER) IS
2465: select authoring_org_id
2466: from okc_k_headers_all_b
2467: where id = p_contract_id;
2468:
2469: item_key_rec item_key_seq%rowtype;
2470: