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_POSITION_ASSIGNMENTS

Line 146: FROM psb_position_assignments ppf

142: c_attribute_id IN NUMBER ,
143: c_budget_year_end_date IN DATE
144: ) IS
145: SELECT ppf.attribute_Value
146: FROM psb_position_assignments ppf
147: WHERE ppf.data_extract_id = c_data_extract_id
148: AND ppf.position_id = c_position_id
149: AND nvl(worksheet_id, -1) = nvl(c_worksheet_id, -1)
150: AND ppf.attribute_id = c_attribute_Id

Line 3118: from PSB_POSITION_ASSIGNMENTS pas,

3114: pas.attribute_value_id,
3115: decode(pas.attribute_value_id,null,pas.attribute_value,patv.attribute_value) attribute_value,
3116: pas.effective_start_date,
3117: pas.effective_end_date
3118: from PSB_POSITION_ASSIGNMENTS pas,
3119: PSB_ATTRIBUTES pat,
3120: PSB_ATTRIBUTE_VALUES patv
3121: where pas.position_id = positionid
3122: and pas.assignment_type = 'ATTRIBUTE'

Line 3126: (select 1 from psb_position_assignments c

3122: and pas.assignment_type = 'ATTRIBUTE'
3123: and ((pas.worksheet_id = p_worksheet_id)
3124: or (worksheet_id is null
3125: and not exists
3126: (select 1 from psb_position_assignments c
3127: where c.position_id = positionid
3128: and c.attribute_id = pas.attribute_id
3129: and c.worksheet_id = p_worksheet_id)))
3130: and pas.attribute_id = pat.attribute_id

Line 3152: from PSB_POSITION_ASSIGNMENTS pas,

3148: pas.element_value,
3149: pas.element_value_type,
3150: pas.currency_code,
3151: pas.pay_basis
3152: from PSB_POSITION_ASSIGNMENTS pas,
3153: PSB_PAY_ELEMENTS pe
3154: where pas.position_id = positionid
3155: and pas.assignment_type = 'ELEMENT'
3156: and ((pas.worksheet_id = p_worksheet_id)

Line 3159: (select 1 from PSB_POSITION_ASSIGNMENTS c

3155: and pas.assignment_type = 'ELEMENT'
3156: and ((pas.worksheet_id = p_worksheet_id)
3157: or (worksheet_id is null
3158: and not exists
3159: (select 1 from PSB_POSITION_ASSIGNMENTS c
3160: where c.position_id = positionid
3161: and c.pay_element_id = pas.pay_element_id
3162: and c.worksheet_id = p_worksheet_id)))
3163: and pas.pay_element_id = pe.pay_element_id;

Line 3184: from PSB_POSITION_ASSIGNMENTS pas

3180: and nvl(a.sequence_number, -1) = nvl(b.sequence_number, -1);
3181:
3182: cursor c_posassign_emp (positionid NUMBER) is
3183: select *
3184: from PSB_POSITION_ASSIGNMENTS pas
3185: where pas.position_id = positionid
3186: and pas.assignment_type = 'EMPLOYEE'
3187: and ((pas.worksheet_id = p_worksheet_id)
3188: or (pas.worksheet_id is null

Line 3190: (select 1 from PSB_POSITION_ASSIGNMENTS c

3186: and pas.assignment_type = 'EMPLOYEE'
3187: and ((pas.worksheet_id = p_worksheet_id)
3188: or (pas.worksheet_id is null
3189: and not exists
3190: (select 1 from PSB_POSITION_ASSIGNMENTS c
3191: where c.position_id = positionid
3192: and c.primary_employee_flag = 'Y'
3193: and c.worksheet_id = p_worksheet_id)));
3194:

Line 3222: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq

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
3223: from dual;
3224:
3225: cursor c_posdistr_seq is
3226: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq

Line 3335: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

3331: for c_posassign_seq_rec in c_posassign_seq loop
3332: l_position_assignment_id := c_posassign_seq_rec.seq;
3333: end loop;
3334:
3335: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
3336: (p_api_version => 1.0,
3337: p_return_status => l_return_status,
3338: p_msg_count => l_msg_count,
3339: p_msg_data => l_msg_data,

Line 3397: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

3393: for c_posassign_seq_rec in c_posassign_seq loop
3394: l_position_assignment_id := c_posassign_seq_rec.seq;
3395: end loop;
3396:
3397: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
3398: (p_api_version => 1.0,
3399: p_return_status => l_return_status,
3400: p_msg_count => l_msg_count,
3401: p_msg_data => l_msg_data,

Line 3443: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

3439: for c_posassign_seq_rec in c_posassign_seq loop
3440: l_position_assignment_id := c_posassign_seq_rec.seq;
3441: end loop;
3442:
3443: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
3444: (p_api_version => 1.0,
3445: p_return_status => l_return_status,
3446: p_msg_count => l_msg_count,
3447: p_msg_data => l_msg_data,

Line 8179: from psb_ws_lines_positions wlp, psb_ws_position_lines wpl, psb_position_assignments ppa

8175: select 'Exists'
8176: from dual
8177: where exists
8178: (select 'Exists'
8179: from psb_ws_lines_positions wlp, psb_ws_position_lines wpl, psb_position_assignments ppa
8180: where wlp.worksheet_id = p_source_id
8181: and wpl.position_line_id = wlp.position_line_id
8182: and ppa.position_id = wpl.position_id
8183: and ppa.pay_element_id = l_element_id

Line 8194: from psb_budget_revision_pos_lines brpl, psb_budget_revision_positions brp, psb_position_assignments ppa

8190: select 'Exists'
8191: from dual
8192: where exists
8193: (select 'Exists'
8194: from psb_budget_revision_pos_lines brpl, psb_budget_revision_positions brp, psb_position_assignments ppa
8195: where brpl.budget_revision_id = p_source_id
8196: and brp.budget_revision_pos_line_id = brpl.budget_revision_pos_line_id
8197: and ppa.position_id = brp.position_id
8198: and ppa.pay_element_id = p_element_id

Line 8663: (select 1 from PSB_POSITION_ASSIGNMENTS d

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
8664: where d.position_id = b.position_id and d.pay_element_id = c.pay_element_id)
8665: and ((b.worksheet_id = p_source_id)
8666: or (b.worksheet_id is null
8667: and not exists

Line 8852: (select 1 from PSB_POSITION_ASSIGNMENTS g

8848: and b.position_set_group_id = c.position_set_group_id
8849: and b.pay_element_id = e.pay_element_id
8850: and c.account_position_set_id = d.account_position_set_id
8851: and exists
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

Line 10906: from psb_position_assignments a,

10902: and pp.hr_position_id = positionid;
10903:
10904: cursor c_job(positionid NUMBER) is
10905: select a.attribute_id, a.attribute_value_id, c.attribute_value , hr_value_id
10906: from psb_position_assignments a,
10907: psb_attributes b,
10908: psb_attribute_values c
10909: where a.position_id = positionid
10910: and a.data_extract_id = p_system_data_extract_id -- system_data_extract_id

Line 10918: from psb_position_assignments a,

10914: and c.data_extract_id = p_system_data_extract_id;
10915:
10916: cursor c_org(positionid NUMBER) is
10917: select a.attribute_id, a.attribute_value_id, c.attribute_value , hr_value_id
10918: from psb_position_assignments a,
10919: psb_attributes b,
10920: psb_attribute_values c
10921: where a.position_id = positionid
10922: and a.data_extract_id = p_system_data_extract_id -- system_data_extract_id

Line 12031: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');

12027: Update psb_default_assignments
12028: set attribute_id = l_sysorg_id
12029: where attribute_id = p_attribute_id;
12030:
12031: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12032: Update psb_position_assignments
12033: set attribute_id = l_sysorg_id
12034: where attribute_id = p_attribute_id;
12035:

Line 12032: Update psb_position_assignments

12028: set attribute_id = l_sysorg_id
12029: where attribute_id = p_attribute_id;
12030:
12031: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12032: Update psb_position_assignments
12033: set attribute_id = l_sysorg_id
12034: where attribute_id = p_attribute_id;
12035:
12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');

Line 12077: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');

12073: Update psb_default_assignments
12074: set attribute_id = p_attribute_id
12075: where attribute_id = l_sysorg_id;
12076:
12077: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12078: Update psb_position_assignments
12079: set attribute_id = p_attribute_id
12080: where attribute_id = l_sysorg_id;
12081:

Line 12078: Update psb_position_assignments

12074: set attribute_id = p_attribute_id
12075: where attribute_id = l_sysorg_id;
12076:
12077: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12078: Update psb_position_assignments
12079: set attribute_id = p_attribute_id
12080: where attribute_id = l_sysorg_id;
12081:
12082: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');