APPS.PSB_POSITIONS_PVT dependencies on PSB_PAY_ELEMENTS

Line 1521: PSB_PAY_ELEMENTS el

1517: a.global_default_flag,
1518: a.assignment_default_rule_id,
1519: a.modify_flag
1520: from PSB_POSITION_ASSIGNMENTS a,
1521: PSB_PAY_ELEMENTS el
1522: where
1523: ( (nvl(a.worksheet_id, FND_API.G_MISS_NUM) = nvl(p_worksheet_id, FND_API.G_MISS_NUM)) OR
1524: (p_worksheet_id is not null and worksheet_id is null
1525: and not exists

Line 1527: psb_position_assignments c ,psb_pay_elements pe2

1523: ( (nvl(a.worksheet_id, FND_API.G_MISS_NUM) = nvl(p_worksheet_id, FND_API.G_MISS_NUM)) OR
1524: (p_worksheet_id is not null and worksheet_id is null
1525: and not exists
1526: (select 1 from
1527: psb_position_assignments c ,psb_pay_elements pe2
1528: where c.position_id = a.position_id
1529: and c.pay_element_id = pe2.pay_element_id
1530: and pe2.salary_flag = 'Y'
1531: and c.worksheet_id = p_worksheet_id

Line 1561: from PSB_PAY_ELEMENTS

1557: and el.salary_flag = 'Y';
1558:
1559: cursor c_Salary is
1560: select salary_flag
1561: from PSB_PAY_ELEMENTS
1562: where pay_element_id = p_pay_element_id;
1563:
1564: /*For Bug No : 2847566 Start*/
1565: Cursor C_Get_Pay_Basis Is

Line 2741: from PSB_PAY_ELEMENTS

2737: and position_id = p_position_id;
2738:
2739: cursor c_Salary is
2740: select salary_flag
2741: from PSB_PAY_ELEMENTS
2742: where pay_element_id = p_pay_element_id;
2743:
2744: l_return_status VARCHAR2(1);
2745: l_msg_count NUMBER;

Line 3740: from PSB_PAY_ELEMENTS pe

3736: PSB_SET_RELATIONS c,
3737: PSB_BUDGET_POSITIONS d
3738: where EXISTS
3739: ( select 1
3740: from PSB_PAY_ELEMENTS pe
3741: where pe.salary_flag <> 'Y'
3742: and pe.data_extract_id = p_data_extract_id
3743: and pe.pay_element_id = a.pay_element_id
3744: )

Line 4317: PSB_PAY_ELEMENTS b

4313:
4314: cursor c_Overlap is
4315: select 'Salary Overlaps'
4316: from PSB_POSITION_ASSIGNMENTS a,
4317: PSB_PAY_ELEMENTS b
4318: where ((((p_effective_end_date is not null)
4319: and ((a.effective_start_date <= p_effective_end_date)
4320: and (a.effective_end_date is null))
4321: or ((a.effective_start_date between p_effective_start_date and p_effective_end_date)

Line 4331: psb_position_assignments c ,psb_pay_elements pe2

4327: and ( (nvl(a.worksheet_id, FND_API.G_MISS_NUM) = nvl(p_worksheet_id, FND_API.G_MISS_NUM)) OR
4328: (p_worksheet_id is not null and worksheet_id is null
4329: and not exists
4330: (select 1 from
4331: psb_position_assignments c ,psb_pay_elements pe2
4332: where c.position_id = a.position_id
4333: and c.pay_element_id = pe2.pay_element_id
4334: and pe2.salary_flag = 'Y'
4335: and c.worksheet_id = p_worksheet_id

Line 4704: FROM psb_pay_elements pe,

4700: --++ use the job's date
4701:
4702: CURSOR c_salary IS
4703: SELECT pass.effective_start_date,pass.effective_end_date,pass.pay_basis
4704: FROM psb_pay_elements pe,
4705: psb_position_assignments pass
4706: WHERE pe.salary_flag = 'Y'
4707: AND pe.pay_element_id = pass.pay_element_id
4708: AND (pass.worksheet_id is NULL OR pass.worksheet_id = p_worksheet_id)

Line 4723: FROM psb_pay_elements pe,

4719: SELECT 'Invalid Pay Basis'
4720: FROM DUAL
4721: WHERE EXISTS
4722: (SELECT 1
4723: FROM psb_pay_elements pe,
4724: psb_position_assignments pass
4725: WHERE NVL(pass.pay_basis,'DUMMY') NOT IN ('ANNUAL', 'HOURLY', 'MONTHLY', 'PERIOD')
4726: AND pe.salary_flag = 'Y'
4727: AND pe.pay_element_id = pass.pay_element_id

Line 4913: psb_pay_elements b,

4909: a.effective_start_date, a.effective_end_date,
4910: e.position_id
4911: FROM
4912: psb_pay_element_distributions a,
4913: psb_pay_elements b,
4914: psb_element_pos_Set_groups c,
4915: psb_set_relations d,
4916: psb_budget_positions e,
4917: psb_position_assignments f

Line 6015: FROM PSB_PAY_ELEMENTS ppay

6011: l_def_salary_flag VARCHAR2(1) := 'N';
6012:
6013: CURSOR l_salary IS
6014: SELECT salary_flag
6015: FROM PSB_PAY_ELEMENTS ppay
6016: WHERE ppay.pay_element_id = l_pay_element_id;
6017:
6018:
6019: CURSOR l_get_pay_basis IS

Line 6040: FROM psb_pay_elements

6036: AND data_extract_id = p_data_extract_id
6037: AND position_id = p_position_id and worksheet_id IS NULL;
6038:
6039: CURSOR l_element IS SELECT pay_element_id,salary_flag
6040: FROM psb_pay_elements
6041: WHERE pay_element_id = l_element_id;
6042:
6043:
6044: BEGIN

Line 6117: psb_pay_elements ppay

6113: IF (l_def_salary_flag = 'Y') THEN
6114:
6115: FOR l_assignment_rec IN (SELECT past.position_assignment_id
6116: FROM psb_position_assignments past ,
6117: psb_pay_elements ppay
6118: WHERE past.data_extract_id = p_data_extract_id
6119: AND ((worksheet_id IS NULL AND p_worksheet_id IS NULL)
6120: OR worksheet_id = p_worksheet_id)
6121: AND past.position_id = p_position_id