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.

[Home] [Help]

APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_ATTRIBUTES

Line 303: (select 1 from PSB_ATTRIBUTES_VL b

299: select *
300: from PSB_ATTRIBUTE_VALUES a
301: where data_extract_id = p_source_data_extract_id
302: and exists
303: (select 1 from PSB_ATTRIBUTES_VL b
304: where b.attribute_id = a.attribute_id
305: and b.business_group_id = p_source_business_group_id)
306: and attribute_value is not null;
307:

Line 3119: PSB_ATTRIBUTES pat,

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'
3123: and ((pas.worksheet_id = p_worksheet_id)

Line 6078: FOR l_att_fte_rec IN (SELECT attribute_id FROM psb_attributes a,

6074: END LOOP;
6075:
6076: -- This cursor gets the Attribute id for the business group
6077: -- associated with the data extract.
6078: FOR l_att_fte_rec IN (SELECT attribute_id FROM psb_attributes a,
6079: psb_data_extracts b
6080: WHERE a.business_group_id = b.business_group_id
6081: AND a.system_attribute_type = 'FTE'
6082: AND b.data_extract_id = l_data_extract_Id)

Line 10907: psb_attributes b,

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
10911: and a.attribute_id = b.attribute_id

Line 10919: psb_attributes b,

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
10923: and a.attribute_id = b.attribute_id

Line 11954: from psb_attributes_vl

11950: l_usrcount NUMBER;
11951:
11952: cursor c_sysorg is
11953: select attribute_id
11954: from psb_attributes_vl
11955: where business_group_id = p_business_group_id
11956: and system_attribute_type = 'ORG';
11957:
11958: BEGIN

Line 12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');

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');
12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

Line 12037: Delete from psb_attributes_tl

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');
12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12041: Delete from psb_attributes

Line 12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');
12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12041: Delete from psb_attributes
12042: where attribute_id = p_attribute_id;
12043:
12044: end;

Line 12041: Delete from psb_attributes

12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12041: Delete from psb_attributes
12042: where attribute_id = p_attribute_id;
12043:
12044: end;
12045: else

Line 12082: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');

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');
12083: Delete from psb_attributes_tl
12084: where attribute_id = p_attribute_id;
12085:
12086: Update psb_attributes_tl

Line 12083: Delete from psb_attributes_tl

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');
12083: Delete from psb_attributes_tl
12084: where attribute_id = p_attribute_id;
12085:
12086: Update psb_attributes_tl
12087: set attribute_id = p_attribute_id

Line 12086: Update psb_attributes_tl

12082: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');
12083: Delete from psb_attributes_tl
12084: where attribute_id = p_attribute_id;
12085:
12086: Update psb_attributes_tl
12087: set attribute_id = p_attribute_id
12088: where attribute_id = l_sysorg_id;
12089:
12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

Line 12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

12086: Update psb_attributes_tl
12087: set attribute_id = p_attribute_id
12088: where attribute_id = l_sysorg_id;
12089:
12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12091: Delete from psb_attributes
12092: where attribute_id = p_attribute_id;
12093:
12094: Update psb_attributes

Line 12091: Delete from psb_attributes

12087: set attribute_id = p_attribute_id
12088: where attribute_id = l_sysorg_id;
12089:
12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12091: Delete from psb_attributes
12092: where attribute_id = p_attribute_id;
12093:
12094: Update psb_attributes
12095: set attribute_id = p_attribute_id

Line 12094: Update psb_attributes

12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12091: Delete from psb_attributes
12092: where attribute_id = p_attribute_id;
12093:
12094: Update psb_attributes
12095: set attribute_id = p_attribute_id
12096: where attribute_id = l_sysorg_id;
12097:
12098: end;