2325: IF ((l_retrieval_options <> 'BEE') OR (l_retrieval_options IS NULL))
2326: THEN
2327: process_otlr_employees
2328: (p_bg_id,
2329: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
2330: -- type conversion from VARCHAR2
2331: p_start_date, --fnd_date.canonical_to_date (p_start_date),
2332: p_end_date, --fnd_date.canonical_to_date (p_end_date),
2333: l_where_clause,
2327: process_otlr_employees
2328: (p_bg_id,
2329: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
2330: -- type conversion from VARCHAR2
2331: p_start_date, --fnd_date.canonical_to_date (p_start_date),
2332: p_end_date, --fnd_date.canonical_to_date (p_end_date),
2333: l_where_clause,
2334: p_retrieval_transaction_code,
2335: l_batch_ref,
2328: (p_bg_id,
2329: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
2330: -- type conversion from VARCHAR2
2331: p_start_date, --fnd_date.canonical_to_date (p_start_date),
2332: p_end_date, --fnd_date.canonical_to_date (p_end_date),
2333: l_where_clause,
2334: p_retrieval_transaction_code,
2335: l_batch_ref,
2336: l_unique_params,
2343: IF ((l_retrieval_options <> 'OTLR') OR (l_retrieval_options IS NULL))
2344: THEN
2345: process_non_otlr_employees
2346: (p_bg_id,
2347: fnd_date.canonical_to_date (p_start_date),
2348: fnd_date.canonical_to_date (p_end_date),
2349: fnd_date.canonical_to_date (p_session_date),
2350: l_where_clause,
2351: p_retrieval_transaction_code,
2344: THEN
2345: process_non_otlr_employees
2346: (p_bg_id,
2347: fnd_date.canonical_to_date (p_start_date),
2348: fnd_date.canonical_to_date (p_end_date),
2349: fnd_date.canonical_to_date (p_session_date),
2350: l_where_clause,
2351: p_retrieval_transaction_code,
2352: l_batch_ref,
2345: process_non_otlr_employees
2346: (p_bg_id,
2347: fnd_date.canonical_to_date (p_start_date),
2348: fnd_date.canonical_to_date (p_end_date),
2349: fnd_date.canonical_to_date (p_session_date),
2350: l_where_clause,
2351: p_retrieval_transaction_code,
2352: l_batch_ref,
2353: l_unique_params,