eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITIONS

Line 2717: FROM psb_positions psb_pos

2713: -- No need of getting the position_start_date as this
2714: -- check no more exists.
2715: /*
2716: SELECT effective_start_date INTO l_pos_start_date
2717: FROM psb_positions psb_pos
2718: WHERE psb_pos.position_id = p_source_DE_position_id;
2719: */
2720:
2721:

Line 3087: from PSB_POSITIONS pos,

3083: pos.attribute6, pos.attribute7, pos.attribute8, pos.attribute9, pos.attribute10,
3084: pos.attribute11, pos.attribute12, pos.attribute13, pos.attribute14, pos.attribute15,
3085: pos.attribute16, pos.attribute17, pos.attribute18, pos.attribute19, pos.attribute20,
3086: pos.attribute_category, pos.name, wpl.budget_group_id
3087: from PSB_POSITIONS pos,
3088: PSB_WS_POSITION_LINES wpl,
3089: PSB_WS_LINES_POSITIONS wlp
3090: where data_extract_id = p_source_data_extract_id
3091: and wpl.position_id = pos.position_id

Line 3097: from PSB_POSITIONS

3093: and wlp.position_line_id = wpl.position_line_id;
3094:
3095: cursor c_position_exists (posname VARCHAR2, hrempid NUMBER, hrposid NUMBER) is
3096: select position_id
3097: from PSB_POSITIONS
3098: where name = posname
3099: and data_extract_id = p_target_data_extract_id
3100: and hr_position_id = hrposid
3101: -- For Bug number 2931727

Line 3106: (select 1 from psb_positions

3102: -- and (hrempid is null or hr_employee_id = hrempid);
3103: and (((hrempid is not null) and ((hr_employee_id = hrempid)
3104: or ((hr_employee_id is null) and
3105: not exists
3106: (select 1 from psb_positions
3107: where hr_position_id = hrposid
3108: and hr_employee_id = hrempid
3109: and data_extract_id = p_target_data_extract_id))))
3110: or ((hrempid is null) and (hr_employee_id is null)));

Line 3218: select PSB_POSITIONS_S.NEXTVAL seq

3214: where c.position_id = positionid
3215: and c.worksheet_id = p_worksheet_id)));
3216:
3217: cursor c_pos_seq is
3218: select PSB_POSITIONS_S.NEXTVAL seq
3219: from dual;
3220:
3221: cursor c_posassign_seq is
3222: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq

Line 3261: PSB_POSITIONS_PVT.Insert_Row

3257: for c_pos_seq_rec in c_pos_seq loop
3258: l_position_id := c_pos_seq_rec.seq;
3259: end loop;
3260:
3261: PSB_POSITIONS_PVT.Insert_Row
3262: (p_api_version => 1.0,
3263: p_return_status => l_return_status,
3264: p_msg_count => l_msg_count,
3265: p_msg_data => l_msg_data,

Line 3631: PSB_POSITIONS_PVT.UPDATE_ROW

3627:
3628:
3629: begin /* Position exists; do an incremental refresh in this case */
3630:
3631: PSB_POSITIONS_PVT.UPDATE_ROW
3632: (
3633: p_api_version => 1.0,
3634: p_init_msg_lISt => FND_API.G_FALSE,
3635: p_commit => FND_API.G_FALSE,

Line 3703: PSB_POSITIONS_PVT.Modify_Assignment

3699: else
3700: l_attribute_value_id := null;
3701: end if;
3702:
3703: PSB_POSITIONS_PVT.Modify_Assignment
3704: (p_api_version => 1.0,
3705: p_return_status => l_return_status,
3706: p_msg_count => l_msg_count,
3707: p_msg_data => l_msg_data,

Line 3761: PSB_POSITIONS_PVT.Modify_Assignment

3757: else
3758: l_pay_element_option_id := null;
3759: end if;
3760:
3761: PSB_POSITIONS_PVT.Modify_Assignment
3762: (p_api_version => 1.0,
3763: p_return_status => l_return_status,
3764: p_msg_count => l_msg_count,
3765: p_msg_data => l_msg_data,

Line 3803: PSB_POSITIONS_PVT.Modify_Assignment

3799: for c_re_emp_rec in c_re_emp (c_posassign_emp_rec.employee_id) loop
3800: l_employee_id := c_re_emp_rec.employee_id;
3801: end loop;
3802:
3803: PSB_POSITIONS_PVT.Modify_Assignment
3804: (p_api_version => 1.0,
3805: p_return_status => l_return_status,
3806: p_msg_count => l_msg_count,
3807: p_msg_data => l_msg_data,

Line 4214: from PSB_POSITIONS a,

4210: and b.pay_element_id = elemid;
4211:
4212: cursor c_re_pos (posid NUMBER) is
4213: select a.position_id, a.budget_group_id
4214: from PSB_POSITIONS a,
4215: PSB_POSITIONS b
4216: where (((b.hr_employee_id is null) and
4217: (a.hr_employee_id is null))
4218: or ((b.hr_employee_id is not null )

Line 4215: PSB_POSITIONS b

4211:
4212: cursor c_re_pos (posid NUMBER) is
4213: select a.position_id, a.budget_group_id
4214: from PSB_POSITIONS a,
4215: PSB_POSITIONS b
4216: where (((b.hr_employee_id is null) and
4217: (a.hr_employee_id is null))
4218: or ((b.hr_employee_id is not null )
4219: and (a.hr_employee_id = b.hr_employee_id)))

Line 5524: from psb_positions

5520: select budget_group_id from psb_budget_revisions where budget_revision_id = p_source_id;
5521:
5522: cursor c_position is
5523: select position_id, name, hr_position_id, hr_employee_id
5524: from psb_positions
5525: where data_extract_id = l_data_extract_id;
5526:
5527: /* Fix for Bug #2642767 Start */
5528: cursor c_no_hr_position (positionid NUMBER) is

Line 5530: from psb_positions

5526:
5527: /* Fix for Bug #2642767 Start */
5528: cursor c_no_hr_position (positionid NUMBER) is
5529: select name, transaction_id
5530: from psb_positions
5531: where position_id = positionid
5532: and hr_position_id is null;
5533: /* Fix for Bug #2642767 End */
5534:

Line 8260: (select hr_employee_id from PSB_POSITIONS

8256: select payroll_id
8257: from per_all_assignments_f
8258: where position_id = p_hr_position_id
8259: and person_id in
8260: (select hr_employee_id from PSB_POSITIONS
8261: where hr_position_id = p_hr_position_id
8262: and data_extract_id = p_data_extract_id)
8263: /*For Bug No : 2292003 Start*/
8264: --and p_effective_start_date between effective_start_date and effective_end_date

Line 8311: from psb_positions

8307: l_no_hr_pos_count NUMBER := 0;
8308:
8309: cursor c_bpposition is
8310: select position_id, name, hr_position_id, hr_employee_id, effective_start_date
8311: from psb_positions
8312: where data_extract_id = p_data_extract_id;
8313:
8314: cursor c_brposition is
8315: select position_id, name, hr_position_id, hr_employee_id, effective_start_date

Line 8316: from psb_positions

8312: where data_extract_id = p_data_extract_id;
8313:
8314: cursor c_brposition is
8315: select position_id, name, hr_position_id, hr_employee_id, effective_start_date
8316: from psb_positions
8317: where data_extract_id = p_system_data_extract_id;
8318:
8319: /* Fix for Bug #2642767 Start */
8320: cursor c_no_hr_position (positionid NUMBER) is

Line 8322: from psb_positions

8318:
8319: /* Fix for Bug #2642767 Start */
8320: cursor c_no_hr_position (positionid NUMBER) is
8321: select name, transaction_id
8322: from psb_positions
8323: where position_id = positionid
8324: and hr_position_id is null;
8325: /* Fix for Bug #2642767 End*/
8326:

Line 8568: psb_positions pp

8564: cursor c_Element_Costs is
8565: select ppe.pay_element_id, ppe.budget_set_id, sum(nvl(ppc.element_cost,0)) element_cost
8566: from psb_pay_elements ppe,
8567: psb_position_costs ppc,
8568: psb_positions pp
8569: where ppe.data_extract_id = p_data_extract_id
8570: and ppc.pay_element_id = ppe.pay_element_id
8571: and pp.data_extract_id = p_data_extract_id
8572: and pp.hr_position_id = p_hr_position_id

Line 8659: (select a.position_id from PSB_POSITIONS a

8655: from PSB_PAY_ELEMENTS c, PSB_POSITION_PAY_DISTRIBUTIONS b
8656: where c.data_extract_id = p_data_extract_id
8657: and c.salary_flag = 'Y'
8658: and b.position_id in
8659: (select a.position_id from PSB_POSITIONS a
8660: where a.hr_position_id = p_hr_position_id
8661: and a.data_extract_id = p_data_extract_id)
8662: and exists
8663: (select 1 from PSB_POSITION_ASSIGNMENTS d

Line 8856: (select f.position_id from PSB_POSITIONS f

8852: (select 1 from PSB_POSITION_ASSIGNMENTS g
8853: where g.position_id = d.position_id
8854: and g.pay_element_id = e.pay_element_id)
8855: and d.position_id in
8856: (select f.position_id from PSB_POSITIONS f
8857: where f.hr_position_id = p_hr_position_id
8858: and f.data_extract_id = p_data_extract_id);
8859: --
8860: BEGIN

Line 9424: from psb_positions pp, psb_position_costs ppc

9420: and date_to = p_end_date;
9421:
9422: cursor c_total_cost_bp is
9423: select sum(ppc.element_cost) total_cost
9424: from psb_positions pp, psb_position_costs ppc
9425: where pp.data_extract_id = p_system_data_extract_id
9426: and exists
9427: (select 'Exists'
9428: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

Line 9428: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

9424: from psb_positions pp, psb_position_costs ppc
9425: where pp.data_extract_id = p_system_data_extract_id
9426: and exists
9427: (select 'Exists'
9428: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp
9429: where pp1.data_extract_id = p_data_extract_id
9430: and pp1.hr_position_id = pp.hr_position_id
9431: and wpl.position_id = pp1.position_id
9432: and wlp.position_line_id = wpl.position_line_id

Line 9454: from psb_positions pp, psb_position_fte ppf

9450: and b.position_id is not null;
9451:
9452: cursor c_total_fte_bp is
9453: select sum(avg(ppf.fte)) total_fte
9454: from psb_positions pp, psb_position_fte ppf
9455: where pp.data_extract_id = p_system_data_extract_id
9456: and exists
9457: (select 'Exists'
9458: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

Line 9458: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp

9454: from psb_positions pp, psb_position_fte ppf
9455: where pp.data_extract_id = p_system_data_extract_id
9456: and exists
9457: (select 'Exists'
9458: from psb_positions pp1, psb_ws_position_lines wpl, psb_ws_lines_positions wlp
9459: where pp1.data_extract_id = p_data_extract_id
9460: and pp1.hr_position_id = pp.hr_position_id
9461: and wpl.position_id = pp1.position_id
9462: and wlp.position_line_id = wpl.position_line_id

Line 10163: psb_positions pp

10159: select ppf.start_date,
10160: ppf.end_date,
10161: sum(ppf.fte) fte
10162: from psb_position_fte ppf,
10163: psb_positions pp
10164: where pp.data_extract_id = p_system_data_extract_id
10165: and pp.hr_position_id = p_hr_position_id
10166: and ppf.position_id = pp.position_id
10167: and ppf.hr_budget_id = p_hr_budget_id

Line 10176: from psb_position_costs ppc, psb_positions pp

10172: or ((ppf.start_date < p_start_date) and (ppf.end_date > p_end_date)))
10173: group by ppf.start_date, ppf.end_date
10174: ) a,
10175: (select ppc.start_date, ppc.end_date, sum(ppc.element_cost) cost
10176: from psb_position_costs ppc, psb_positions pp
10177: where pp.data_extract_id = p_system_data_extract_id
10178: and pp.hr_position_id = p_hr_position_id
10179: and ppc.position_id = pp.position_id
10180: and ppc.hr_budget_id = p_hr_budget_id

Line 10221: psb_positions pp

10217: select ppe.budget_set_id hr_budget_set_id,
10218: sum(nvl(ppc.element_cost,0)) budget_set_cost
10219: from psb_pay_elements ppe,
10220: psb_position_costs ppc,
10221: psb_positions pp
10222: where ppe.data_extract_id = p_system_data_extract_id
10223: and pp.hr_position_id = p_hr_position_id
10224: and pp.data_extract_id = p_system_data_extract_id
10225: and ppc.position_id = pp.position_id

Line 10839: from psb_positions pp, psb_position_fte ppf

10835: (
10836: select pp.hr_position_id fte_position_id, sum(avg_fte) fte
10837: from
10838: (select pp.position_id, avg(ppf.fte) avg_fte
10839: from psb_positions pp, psb_position_fte ppf
10840: where ppf.position_id = pp.position_id
10841: and ppf.base_line_version = 'C'
10842: and ppf.hr_budget_id = p_hr_budget_id
10843: and ((ppf.start_date between p_start_date and p_end_date)

Line 10846: group by pp.position_id) pf, psb_positions pp

10842: and ppf.hr_budget_id = p_hr_budget_id
10843: and ((ppf.start_date between p_start_date and p_end_date)
10844: or (ppf.end_date between p_start_date and p_end_date)
10845: or ((ppf.start_date < p_start_date) and (ppf.end_date > p_end_date)))
10846: group by pp.position_id) pf, psb_positions pp
10847: where pp.data_extract_id = p_system_data_extract_id
10848: and pp.position_id = pf.position_id
10849: group by pp.hr_position_id
10850: ) a,

Line 10853: from psb_position_costs ppc, psb_positions pp

10849: group by pp.hr_position_id
10850: ) a,
10851: (
10852: select pp.hr_position_id cost_position_id, sum(ppc.element_cost) cost
10853: from psb_position_costs ppc, psb_positions pp
10854: where pp.data_extract_id = p_system_data_extract_id
10855: and ppc.hr_budget_id = p_hr_budget_id
10856: and ppc.position_id = pp.position_id
10857: and ppc.base_line_version = 'C'

Line 10868: from psb_positions

10864: where a.fte_position_id = b.cost_position_id;
10865:
10866: cursor c_hr_position (positionid NUMBER) is
10867: select position_id, hr_employee_id, name, effective_start_date
10868: from psb_positions
10869: where data_extract_id = decode(p_event_type, 'BP', p_data_extract_id, p_system_data_extract_id)
10870: and hr_position_id = positionid
10871: and rownum < 2;
10872:

Line 10875: from psb_positions

10871: and rownum < 2;
10872:
10873: cursor c_att_position (positionid NUMBER) is
10874: select position_id
10875: from psb_positions
10876: where data_extract_id = p_system_data_extract_id
10877: and hr_position_id = positionid
10878: and rownum < 2;
10879:

Line 10897: psb_positions pp

10893: select sum(decode(b.revision_type, 'I', b.revision_amount,
10894: 'D', -b.revision_amount)) revision_amount
10895: from psb_budget_revision_lines a,
10896: psb_budget_revision_accounts b,
10897: psb_positions pp
10898: where a.budget_revision_id = p_source_id
10899: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id
10900: and pp.position_id = b.position_id
10901: and pp.data_extract_id = p_system_data_extract_id