APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 2322: FROM psb_position_pay_distributions b

2318: chart_of_accounts_id, code_combination_id, distribution_percent,
2319: global_default_flag, distribution_default_rule_id, project_id,
2320: task_id, award_id, expenditure_type, expenditure_organization_id,
2321: cost_allocation_key_flex_id, description
2322: FROM psb_position_pay_distributions b
2323: WHERE (((l_year_end_date IS NOT NULL)
2324: AND (((b.effective_start_date <= l_year_end_date)
2325: AND (b.effective_end_date IS NULL))
2326: OR ((b.effective_start_date

Line 2349: PSB_POSITION_PAY_DISTRIBUTIONS pos_distr

2345: pos_distr.distribution_id, pos_distr.effective_start_date,
2346: pos_distr.effective_end_date, pos_distr.chart_of_accounts_id,
2347: pos_distr.code_combination_id, pos_distr.distribution_percent
2348: FROM
2349: PSB_POSITION_PAY_DISTRIBUTIONS pos_distr
2350: WHERE EXISTS
2351: (
2352: SELECT 1
2353: FROM psb_ws_account_lines ws_lines

Line 2367: FROM PSB_POSITION_PAY_DISTRIBUTIONS pay_distr

2363: (pos_distr.worksheet_id = p_worksheet_id)
2364: OR (pos_distr.worksheet_id IS NULL
2365: AND NOT EXISTS
2366: (SELECT 1
2367: FROM PSB_POSITION_PAY_DISTRIBUTIONS pay_distr
2368: WHERE pay_distr.position_id = pos_distr.position_id
2369: AND pay_distr.worksheet_id = p_worksheet_id
2370: )
2371: )

Line 2633: DELETE FROM psb_position_pay_distributions

2629: -- Now manipulated distributions are in the PL/SQL table.
2630: -- Delete c_pos_distr records and insert PL/SQL table records.
2631:
2632: FORALL i in 1..rec_distribution_id.COUNT
2633: DELETE FROM psb_position_pay_distributions
2634: WHERE distribution_id = rec_distribution_id(i);
2635:
2636: /* Bug 4060926 Start */
2637: l_debug_info := ' Bulk Deletion of the existing disr completed.';

Line 2641: INSERT INTO psb_position_pay_distributions(

2637: l_debug_info := ' Bulk Deletion of the existing disr completed.';
2638: /* Bug 4060926 Start */
2639:
2640: FORALL i in 1..l_count_ins_rec
2641: INSERT INTO psb_position_pay_distributions(
2642: distribution_id, position_id, data_extract_id,
2643: worksheet_id, effective_start_date, effective_end_date,
2644: chart_of_accounts_id, code_combination_id, distribution_percent,
2645: global_default_flag, distribution_default_rule_id, project_id,

Line 3208: from PSB_POSITION_PAY_DISTRIBUTIONS a

3204: and b.employee_id = empid;
3205:
3206: cursor c_position_distr (positionid NUMBER) is
3207: select *
3208: from PSB_POSITION_PAY_DISTRIBUTIONS a
3209: where a.position_id = positionid
3210: and ((a.worksheet_id = p_worksheet_id)
3211: or (a.worksheet_id is null
3212: and not exists

Line 3213: (select 1 from PSB_POSITION_PAY_DISTRIBUTIONS c

3209: where a.position_id = positionid
3210: and ((a.worksheet_id = p_worksheet_id)
3211: or (a.worksheet_id is null
3212: and not exists
3213: (select 1 from PSB_POSITION_PAY_DISTRIBUTIONS c
3214: where c.position_id = positionid
3215: and c.worksheet_id = p_worksheet_id)));
3216:
3217: cursor c_pos_seq is

Line 8655: from PSB_PAY_ELEMENTS c, PSB_POSITION_PAY_DISTRIBUTIONS b

8651:
8652: cursor c_Dist is
8653: select distinct c.pay_element_id, b.code_combination_id,
8654: b.distribution_percent
8655: from PSB_PAY_ELEMENTS c, PSB_POSITION_PAY_DISTRIBUTIONS b
8656: where c.data_extract_id = p_data_extract_id
8657: and c.salary_flag = 'Y'
8658: and b.position_id in
8659: (select a.position_id from PSB_POSITIONS a

Line 8668: (select 1 from PSB_POSITION_PAY_DISTRIBUTIONS c

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
8668: (select 1 from PSB_POSITION_PAY_DISTRIBUTIONS c
8669: where c.position_id = b.position_id
8670: and c.worksheet_id = p_source_id)))
8671: and b.chart_of_accounts_id = p_gl_flex_code
8672: and b.code_combination_id is not null