APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_SALARIES

Line 329: DELETE FROM hr_h2pi_salaries

325: DELETE FROM hr_h2pi_city_tax_rules
326: WHERE client_id = p_from_client_id
327: AND status = 'C';
328:
329: DELETE FROM hr_h2pi_salaries
330: WHERE client_id = p_from_client_id
331: AND status = 'C';
332:
333: DELETE FROM hr_h2pi_cost_allocations

Line 411: FROM hr_h2pi_salaries

407: WHERE (status IS NULL OR status <> 'C')
408: AND client_id = p_bg_id
409: UNION
410: SELECT DISTINCT person_id
411: FROM hr_h2pi_salaries
412: WHERE (status IS NULL OR status <> 'C')
413: AND client_id = p_bg_id
414: UNION
415: SELECT DISTINCT person_id

Line 509: FROM HR_H2PI_SALARIES

505: change_date eff_date,
506: 6 ord,
507: 'upload_salary' fn_name,
508: DECODE(last_upd_date, g_eot, 1, 2) sub_order
509: FROM HR_H2PI_SALARIES
510: WHERE (status IS NULL OR status <> 'C')
511: AND person_id = p_per_id
512: AND client_id = p_from_client_id
513: UNION

Line 2482: FROM hr_h2pi_salaries ppp

2478: p_effective_start_date DATE) IS
2479:
2480: CURSOR csr_ud_salary (p_ppp_id NUMBER) IS
2481: SELECT *
2482: FROM hr_h2pi_salaries ppp
2483: WHERE ppp.pay_proposal_id = p_ppp_id
2484: AND ppp.client_id = p_from_client_id;
2485:
2486: CURSOR csr_ed_salary (p_ppp_id NUMBER) IS

Line 2506: v_ud_ppp hr_h2pi_salaries%ROWTYPE;

2502:
2503: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2504: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
2505: l_ovn per_pay_proposals.object_version_number%TYPE;
2506: v_ud_ppp hr_h2pi_salaries%ROWTYPE;
2507:
2508: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2509: l_inv_next_sal_date_warning BOOLEAN;
2510: l_proposed_salary_warning BOOLEAN;

Line 2596: p_table_name => 'HR_H2PI_SALARIES',

2592: ROLLBACK;
2593: hr_utility.set_location(l_proc, 70);
2594: hr_h2pi_error.data_error
2595: (p_from_id => l_pay_proposal_id,
2596: p_table_name => 'HR_H2PI_SALARIES',
2597: p_message_level => 'FATAL',
2598: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
2599: COMMIT;
2600: RAISE MAPPING_ID_INVALID;

Line 2641: UPDATE hr_h2pi_salaries ppp

2637: );
2638: END IF;
2639:
2640: hr_utility.set_location(l_proc, 90);
2641: UPDATE hr_h2pi_salaries ppp
2642: SET status = 'C'
2643: WHERE ppp.pay_proposal_id = v_ud_ppp.pay_proposal_id
2644: AND ppp.client_id = p_from_client_id;
2645: CLOSE csr_ud_salary;

Line 2657: p_table_name => 'HR_H2PI_SALARIES',

2653: hr_utility.set_location(l_proc, 110);
2654: l_encoded_message := fnd_message.get_encoded;
2655: hr_h2pi_error.data_error
2656: (p_from_id => v_ud_ppp.pay_proposal_id,
2657: p_table_name => 'HR_H2PI_SALARIES',
2658: p_message_level => 'FATAL',
2659: p_message_text => l_encoded_message);
2660: COMMIT;
2661: RAISE;