APPS.PSB_POSITIONS_PVT dependencies on DUAL

Line 2763: -- and not individually as the input salary(pay element id). The main api modify_assignments

2759: end loop;
2760:
2761: if not FND_API.to_Boolean(l_assignment_found) then
2762: -- removed salary validation since we now process salary as a set of all salary elements
2763: -- and not individually as the input salary(pay element id). The main api modify_assignments
2764: -- should process all the overlaps records - deleting all existing overlaps
2765:
2766: begin
2767:

Line 3508: FROM dual

3504: /* For Bug 4644241 --> Reverting Back to the old fix
3505: This will maintain the old functionality */
3506: OPEN l_global_dist_csr FOR
3507: SELECT 'Exists'
3508: FROM dual
3509: WHERE EXISTS
3510: (SELECT 1
3511: FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
3512: PSB_DEFAULTS b

Line 3597: FROM dual

3593: This will maintain the old functionality */
3594:
3595: OPEN l_global_dist_csr FOR
3596: SELECT 'Exists'
3597: FROM dual
3598: WHERE EXISTS
3599: (SELECT 1
3600: FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
3601: PSB_DEFAULTS b

Line 3934: FROM dual

3930: l_distr_exists := TRUE;
3931:
3932: IF l_worksheet_id IS NULL THEN
3933: FOR l_pos_distr_rec IN ( SELECT 1
3934: FROM dual
3935: WHERE NOT EXISTS ( SELECT 1
3936: FROM psb_position_pay_distributions
3937: WHERE position_id = p_position_id
3938: AND data_extract_id = p_data_extract_id

Line 3945: FROM dual

3941: l_distr_exists := FALSE;
3942: END LOOP;
3943: ELSE
3944: FOR l_pos_distr_rec IN ( SELECT 1
3945: FROM dual
3946: WHERE NOT EXISTS ( SELECT 1
3947: FROM psb_position_pay_distributions
3948: WHERE position_id = p_position_id
3949: AND data_extract_id = p_data_extract_id

Line 4688: FROM dual

4684: WHERE worksheet_id = p_worksheet_id;
4685:
4686: CURSOR c_job IS
4687: SELECT 'Job Exists'
4688: FROM dual
4689: WHERE exists
4690: (SELECT 1
4691: FROM psb_attribute_values patv,
4692: psb_position_assignments pass,

Line 4720: FROM DUAL

4716: --++ salary cursor
4717:
4718: CURSOR c_pay_basis IS
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

Line 4754: FROM dual

4750: --- */
4751:
4752: CURSOR c_weekly_hours IS
4753: SELECT 'Default Weekly Hours Exists'
4754: FROM dual
4755: WHERE exists
4756: (SELECT 1
4757: FROM psb_attributes pat,
4758: psb_position_assignments pass