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 685: from fnd_sessions

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

Line 734: fnd_sessions SESH

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

Line 903: ,fnd_sessions s

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

Line 933: from pay_all_payrolls_f pay, fnd_sessions f

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

Line 971: fnd_sessions f

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

Line 1267: fnd_sessions f

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

Line 1278: fnd_sessions f

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

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

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

Line 1826: from fnd_sessions

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