APPS.PSB_POSITIONS_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 3467: FROM PSB_POSITION_PAY_DISTRIBUTIONS

3463:
3464: CURSOR l_distribution_id_csr
3465: IS
3466: SELECT *
3467: FROM PSB_POSITION_PAY_DISTRIBUTIONS
3468: WHERE (((p_position_end_date IS NOT NULL)
3469: AND (((effective_start_date <= p_position_end_date)
3470: AND (effective_end_date IS NULL))
3471: OR ((effective_start_date BETWEEN p_position_start_date AND p_position_end_date)

Line 3481: (SELECT 1 FROM psb_position_pay_distributions

3477: AND data_extract_id = p_data_extract_id
3478: AND position_id = p_position_id
3479: /* Bug 4545909 Start */
3480: AND ((worksheet_id IS NULL AND NOT EXISTS
3481: (SELECT 1 FROM psb_position_pay_distributions
3482: WHERE worksheet_id = p_worksheet_id
3483: AND position_id = p_position_id))
3484: OR worksheet_id = p_worksheet_id
3485: OR(worksheet_id IS NULL AND p_worksheet_id IS NULL));

Line 3936: FROM psb_position_pay_distributions

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
3939: AND worksheet_id IS NULL))
3940: LOOP

Line 3947: FROM psb_position_pay_distributions

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
3950: AND worksheet_id = l_worksheet_id))
3951: LOOP

Line 4848: FROM psb_position_pay_distributions a

4844: SELECT code_combination_id,
4845: distribution_percent,
4846: effective_start_date,
4847: effective_end_date
4848: FROM psb_position_pay_distributions a
4849: WHERE code_combination_id is not null
4850: AND chart_of_accounts_id = p_chart_of_accounts_id
4851: AND (worksheet_id is null
4852: AND NOT EXISTS

Line 4854: FROM psb_position_pay_distributions c

4850: AND chart_of_accounts_id = p_chart_of_accounts_id
4851: AND (worksheet_id is null
4852: AND NOT EXISTS
4853: (SELECT 1
4854: FROM psb_position_pay_distributions c
4855: WHERE (
4856: ( NVL(c.effective_start_date, l_end_est_date + 1)
4857: BETWEEN NVL(a.effective_start_date, l_end_est_date)
4858: AND NVL(a.effective_end_date, NVL(l_end_est_date, c.effective_start_date)))

Line 5399: FROM psb_position_pay_distributions

5395: SELECT x_sum.sum_tot,x_sum.start_date
5396: FROM
5397: (SELECT SUM(distribution_percent) sum_tot ,
5398: effective_start_date start_date
5399: FROM psb_position_pay_distributions
5400: WHERE code_combination_id IS NOT NULL
5401: AND worksheet_id is null
5402: AND position_id = p_position_id
5403: AND (((effective_start_date <= p_effective_end_date)

Line 5417: FROM psb_position_pay_distributions

5413: SELECT x_sum.sum_tot,x_sum.start_date
5414: FROM
5415: (SELECT SUM(distribution_percent) sum_tot ,
5416: effective_start_date start_date
5417: FROM psb_position_pay_distributions
5418: WHERE code_combination_id IS NOT NULL
5419: AND worksheet_id = p_worksheet_id
5420: AND position_id = p_position_id
5421: AND (((effective_start_date <= p_effective_end_date)

Line 5449: FROM psb_position_pay_distributions

5445: FOR l_distributions_rec IN
5446:
5447: (SELECT position_id,
5448: code_combination_id
5449: FROM psb_position_pay_distributions
5450: WHERE position_id = p_position_id
5451: AND code_combination_id IS NOT NULL
5452: AND (((effective_start_date <= p_effective_end_date)
5453: AND (effective_end_date is null))