APPS.HR_GENERAL dependencies on FND_SESSIONS

Line 32: a row in fnd_sessions every time we

28: 16 Jan 95 N Simpson Added overloaded default_currency_code
29: using business group
30: 15 Mar 95 R Fine Allowed a session date to be passed in
31: to init_forms. Now that we have to put
32: a row in fnd_sessions every time we
33: open a form, the initial value is not
34: always sysdate.
35: 18 Apr 95 N Simpson Added check_HR_version
36: 23 Jun 95 D Kerr Added bg_name and bg_legislation_code

Line 687: from fnd_sessions

683: function EFFECTIVE_DATE return date is
684: l_effective_date date ;
685: cursor c1 is
686: select effective_date
687: from fnd_sessions
688: where session_id = userenv('sessionid');
689: begin
690:
691: open c1 ;

Line 736: fnd_sessions SESH

732: --
733: cursor csr_currency is
734: select currency_code
735: from fnd_currencies CURRENCY,
736: fnd_sessions SESH
737: where currency.enabled_flag = 'Y'
738: and currency.issuing_territory_code = p_legislation_code
739: and sesh.session_id = userenv ('sessionid')
740: and sesh.effective_date between nvl(currency.start_date_active,

Line 905: ,fnd_sessions s

901: --
902: cursor csr_lookup is
903: select name
904: from ben_pgm_f pgm
905: ,fnd_sessions s
906: where pgm_id = p_grade_ladder_pgm_id
907: and s.effective_date between
908: pgm.effective_start_date and pgm.effective_end_date
909: and s.session_id = userenv ('sessionid');

Line 935: from pay_all_payrolls_f pay, fnd_sessions f

931: p_payroll_id number) return varchar2 is
932: --
933: cursor csr_lookup is
934: select payroll_name
935: from pay_all_payrolls_f pay, fnd_sessions f
936: where payroll_id = p_payroll_id
937: and f.effective_date between
938: pay.effective_start_date and pay.effective_end_date
939: and f.session_id = userenv ('sessionid');

Line 973: fnd_sessions f

969: select eev.screen_entry_value
970: from pay_element_entry_values_f eev,
971: per_pay_bases ppb,
972: pay_element_entries_f pe,
973: fnd_sessions f
974: where ppb.pay_basis_id +0 = p_pay_basis_id
975: and pe.assignment_id = p_assignment_id
976: and eev.input_value_id = ppb.input_value_id
977: and eev.element_entry_id = pe.element_entry_id

Line 1269: fnd_sessions f

1265:
1266: cursor csr_phones1 is
1267: select phone_number
1268: from per_phones phn,
1269: fnd_sessions f
1270: where phn.parent_id = p_person_id
1271: and phn.parent_table = 'PER_ALL_PEOPLE_F'
1272: and phn.phone_type = 'H1'
1273: and f.effective_date between phn.date_from and

Line 1280: fnd_sessions f

1276:
1277: cursor csr_phones2 is
1278: select telephone_number_1
1279: from per_addresses adr,
1280: fnd_sessions f
1281: where adr.person_id = p_person_id
1282: and adr.primary_flag = 'Y'
1283: and f.effective_date between adr.date_from and
1284: nvl(adr.date_to,f.effective_date)

Line 1494: -- update the row just inserted in fnd_sessions to the date passed

1490: p_sys_date => p_sys_date,
1491: p_commit => l_commit_flag);
1492: --
1493: -- If there was a session date passed in, and it's not sysdate,
1494: -- update the row just inserted in fnd_sessions to the date passed
1495: -- in. This is not the most efficient way to do it, but it means no
1496: -- change is needed to dt_fndate.
1497: --
1498: if l_session_date = nvl (p_session_date, l_session_date) then

Line 1828: from fnd_sessions

1824: psf.effective_start_date and psf.effective_end_date;
1825: --
1826: cursor c_session_date is
1827: select effective_date
1828: from fnd_sessions
1829: where session_id = userenv('sessionid');
1830: --
1831: v_position_latest_name hr_all_positions_f_tl.name%TYPE := null;
1832: l_hr_pos_name_profile_value varchar2(20);