DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on FND_SESSIONS

Line 3619: FND_SESSIONS SS

3615:
3616: CURSOR csr_cost_allocation_keyflex_id IS
3617: SELECT cost_allocation_keyflex_id
3618: FROM PAY_ALL_PAYROLLS_F pay,
3619: FND_SESSIONS SS
3620: WHERE SS.SESSION_ID = USERENV( 'sessionid')
3621: AND PAY.EFFECTIVE_START_DATE <= ss.effective_date
3622: AND PAY.EFFECTIVE_END_DATE >= ss.effective_date
3623: AND pay.payroll_id =

Line 3627: FND_SESSIONS SS

3623: AND pay.payroll_id =
3624: (SELECT pos.pay_freq_payroll_id
3625: FROM pqh_budget_details bdt,
3626: hr_all_positions_f pos,
3627: FND_SESSIONS SS
3628: WHERE bdt.budget_detail_id = p_budget_detail_id
3629: AND bdt.position_id = pos.position_id
3630: AND SS.SESSION_ID = USERENV( 'sessionid')
3631: AND POS.EFFECTIVE_START_DATE <= ss.effective_date