[Home] [Help]
71: FROM dual;
72:
73: -- Set up effective Date
74: Select count(*) into l_cnt
75: from fnd_sessions
76: where session_id = lsession
77: and effective_date = p_date;
78:
79: if (l_cnt = 0 ) then
76: where session_id = lsession
77: and effective_date = p_date;
78:
79: if (l_cnt = 0 ) then
80: INSERT INTO fnd_sessions
81: (session_id,effective_date)
82: values (lsession,p_date);
83: end if;
84:
186: pp.entry_grade_rule_id,
187: pp.entry_step_id,
188: pp.pay_basis_id,
189: pst.system_type_cd
190: FROM fnd_sessions fs,
191: hr_all_positions_f pp ,
192: per_shared_types pst ,
193: per_all_assignments_f paf ,
194: pay_all_payrolls_f ppay,
252: pp.entry_grade_rule_id,
253: pp.entry_step_id,
254: pp.pay_basis_id,
255: pst.system_type_cd
256: FROM fnd_sessions fs,
257: hr_all_positions_f pp ,
258: per_shared_types pst
259: WHERE fs.session_id = userenv('sessionid')
260: AND fs.effective_date between pp.effective_start_date
358: having count(*) > 1;
359:
360: Cursor C_session is
361: SELECT effective_date
362: FROM FND_SESSIONS
363: WHERE session_id = USERENV('sessionid');
364:
365: Cursor C_grade_spine is
366: SELECT grade_spine_id
1089: where business_group_id = p_business_group_id; */
1090: --
1091: Cursor C_session is
1092: SELECT effective_date
1093: FROM FND_SESSIONS
1094: WHERE session_id = USERENV('sessionid');
1095: --
1096: Cursor C_rate is
1097: SELECT name
1691: ppf.effective_start_date,
1692: ppb.pay_basis,
1693: ppb.rate_basis,
1694: ppb.rate_id
1695: FROM fnd_sessions fs,
1696: /* Start bug #4128475 */
1697: -- psb_positions,
1698: psb_positions_i pp,
1699: /* End bug #4128475 */
1760: AND psp.assignment_id = l_assignment_id;
1761:
1762: Cursor C_session is
1763: SELECT effective_date
1764: FROM FND_SESSIONS
1765: WHERE session_id = USERENV('sessionid');
1766:
1767: Cursor C_grade is
1768: SELECT pgs.grade_id,pgs.parent_spine_id,
2308: paf.pay_basis_id,
2309: pcaf.cost_allocation_keyflex_id,
2310: pcaf.effective_start_date,
2311: pcaf.effective_end_date
2312: from fnd_sessions fs, per_all_assignments_f paf,
2313: pay_cost_allocations_f pcaf,
2314: pay_cost_allocation_keyflex pcak
2315: where fs.session_id = userenv('sessionid')
2316: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2337: paf.pay_basis_id,
2338: to_number(null),
2339: to_date(null),
2340: to_date(null)
2341: from fnd_sessions fs, per_all_assignments_f paf
2342: where fs.session_id = userenv('sessionid')
2343: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2344: and paf.business_group_id = p_business_group_id
2345: and paf.payroll_id > l_restart_payroll_id
2849: v_gldummy number;
2850:
2851: Cursor C_Element_Type is
2852: Select element_type_id
2853: from fnd_sessions fs, pay_input_values piv,
2854: per_pay_bases ppb,
2855: per_all_assignments_f paf
2856: where fs.session_id = userenv('sessionid')
2857: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
4413: b.effective_start_date,
4414: b.effective_end_date,
4415: a.effective_start_date date_effective,
4416: a.effective_end_date date_end
4417: from fnd_sessions d, per_all_assignments_f b, hr_all_positions_f a , psb_positions_i c, psb_employees_i e
4418: where d.session_id = userenv('sessionid')
4419: and d.effective_date between a.effective_start_date and a.effective_end_date
4420: and d.effective_date between b.effective_start_date and b.effective_end_date
4421: and a.business_group_id = p_business_group_id
4458: to_date(NULL),
4459: to_date(NULL),
4460: a.effective_start_date date_effective,
4461: a.effective_end_date date_end
4462: from fnd_sessions b , hr_all_positions_f a , psb_positions_i c
4463: where b.session_id = userenv('sessionid')
4464: and b.effective_date between a.effective_start_date and a.effective_end_date
4465: and a.business_group_id = p_business_group_id
4466: and a.position_id = c.hr_position_id
4665:
4666: /*For Bug No : 2109120 Start*/
4667: CURSOR C_check_FTE(l_pos_id NUMBER) IS
4668: SELECT sum(nvl(value,1)) sum_fte
4669: FROM fnd_sessions fs,
4670: per_assignment_budget_values pab,
4671: per_all_assignments_f paf,
4672: per_assignment_status_types past
4673: WHERE fs.session_id = userenv('sessionid')
5786: SELECT effective_start_date
5787: FROM (
5788: SELECT a.effective_start_date
5789: FROM per_all_assignments_f a,
5790: fnd_sessions b,
5791: per_assignment_status_types c
5792: WHERE a.position_id = Employee_rec.position_id
5793: AND a.assignment_status_type_id = c.assignment_status_type_id
5794: AND c.per_system_status = 'TERM_ASSIGN'
5884: FOR l_date_rec IN ( SELECT effective_start_date
5885: FROM (
5886: SELECT a.effective_start_date
5887: FROM per_all_assignments_f a,
5888: fnd_sessions b,
5889: per_assignment_status_types c
5890: WHERE a.position_id = Employee_rec.position_id
5891: AND a.assignment_status_type_id = c.assignment_status_type_id
5892: AND c.per_system_status = 'TERM_ASSIGN'
7362:
7363: PROCEDURE Final_Process is
7364: Begin
7365:
7366: Delete fnd_sessions
7367: where session_id = (select USERENV('sessionid') from dual);
7368:
7369: End Final_Process;
7370: