APPS.POA_SAVINGS_MAIN dependencies on FND_PROFILE

Line 36: l_batch_size NUMBER := fnd_profile.value('POA_COLLECTION_BATCH_SIZE');

32: l_poa_schema VARCHAR2(30);
33: l_stmt VARCHAR2(120);
34: l_status VARCHAR2(30);
35: l_industry VARCHAR2(30);
36: l_batch_size NUMBER := fnd_profile.value('POA_COLLECTION_BATCH_SIZE');
37: l_no_batch NUMBER;
38: cursor v_changed_rows(p_start_date date,p_end_date date,p_batch_size number) is
39: SELECT PO_DISTRIBUTION_ID, 1,ceil(rownum/p_batch_size)
40: FROM (SELECT pod.PO_DISTRIBUTION_ID,pol.item_id,pod.creation_date