APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_PAYMENT_METHODS

Line 158: INSERT INTO hr_h2pi_payment_methods

154: AND sasg.effective_start_date = asg.effective_end_date + 1
155: AND sasg.person_id = asg.person_id);
156:
157: hr_utility.set_location(l_proc, 40);
158: INSERT INTO hr_h2pi_payment_methods
159: (personal_payment_method_id,
160: effective_start_date,
161: effective_end_date,
162: last_upd_date,

Line 177: FROM hr_h2pi_payment_methods

173: p_from_client_id,
174: person_id,
175: -1,
176: -1
177: FROM hr_h2pi_payment_methods
178: WHERE client_id = p_from_client_id
179: GROUP BY person_id, personal_payment_method_id,business_group_id
180: HAVING MAX(effective_end_date) <> g_eot;
181:

Line 337: DELETE FROM hr_h2pi_payment_methods

333: DELETE FROM hr_h2pi_cost_allocations
334: WHERE client_id = p_from_client_id
335: AND status = 'C';
336:
337: DELETE FROM hr_h2pi_payment_methods
338: WHERE client_id = p_from_client_id
339: AND status = 'C';
340:
341: DELETE FROM hr_h2pi_element_names

Line 416: FROM hr_h2pi_payment_methods

412: WHERE (status IS NULL OR status <> 'C')
413: AND client_id = p_bg_id
414: UNION
415: SELECT DISTINCT person_id
416: FROM hr_h2pi_payment_methods
417: WHERE (status IS NULL OR status <> 'C')
418: AND client_id = p_bg_id
419: UNION
420: SELECT DISTINCT person_id

Line 519: FROM HR_H2PI_PAYMENT_METHODS

515: effective_start_date eff_date,
516: 7 ord,
517: 'upload_payment_method' fn_name,
518: DECODE(last_upd_date, g_eot, 1, 2) sub_order
519: FROM HR_H2PI_PAYMENT_METHODS
520: WHERE (status IS NULL OR status <> 'C')
521: AND person_id = p_per_id
522: AND client_id = p_from_client_id
523: UNION

Line 2673: FROM hr_h2pi_payment_methods ppm

2669:
2670: CURSOR csr_ud_payment_method (p_ppm_id NUMBER,
2671: p_esd DATE) IS
2672: SELECT *
2673: FROM hr_h2pi_payment_methods ppm
2674: WHERE ppm.personal_payment_method_id = p_ppm_id
2675: AND ppm.client_id = p_from_client_id
2676: AND ppm.effective_start_date = p_esd;
2677:

Line 2681: FROM hr_h2pi_payment_methods_v ppm

2677:
2678: CURSOR csr_ed_payment_method (p_ppm_id NUMBER,
2679: p_esd DATE) IS
2680: SELECT *
2681: FROM hr_h2pi_payment_methods_v ppm
2682: WHERE ppm.personal_payment_method_id = p_ppm_id
2683: AND p_esd BETWEEN ppm.effective_start_date
2684: AND ppm.effective_end_date;
2685:

Line 2699: v_ud_ppm hr_h2pi_payment_methods%ROWTYPE;

2695: l_encoded_message VARCHAR2(200);
2696:
2697: l_proc VARCHAR2(72) := g_package||'upload_payment_method';
2698:
2699: v_ud_ppm hr_h2pi_payment_methods%ROWTYPE;
2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;
2701:
2702: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2703: l_personal_pay_method_id

Line 2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;

2696:
2697: l_proc VARCHAR2(72) := g_package||'upload_payment_method';
2698:
2699: v_ud_ppm hr_h2pi_payment_methods%ROWTYPE;
2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;
2701:
2702: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2703: l_personal_pay_method_id
2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

Line 2900: p_table_name => 'HR_H2PI_PAYMENT_METHODS',

2896: ROLLBACK;
2897: hr_utility.set_location(l_proc, 120);
2898: hr_h2pi_error.data_error
2899: (p_from_id => l_personal_pay_method_id,
2900: p_table_name => 'HR_H2PI_PAYMENT_METHODS',
2901: p_message_level => 'FATAL',
2902: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
2903: COMMIT;
2904: RAISE MAPPING_ID_INVALID;

Line 3039: UPDATE hr_h2pi_payment_methods ppm

3035: END IF;
3036: END IF;
3037:
3038: hr_utility.set_location(l_proc, 200);
3039: UPDATE hr_h2pi_payment_methods ppm
3040: SET status = 'C'
3041: WHERE ppm.personal_payment_method_id = v_ud_ppm.personal_payment_method_id
3042: AND ppm.client_id = p_from_client_id
3043: AND ppm.effective_start_date = v_ud_ppm.effective_start_date

Line 3057: p_table_name => 'HR_H2PI_PAYMENT_METHODS',

3053: hr_utility.set_location(l_proc, 230);
3054: l_encoded_message := fnd_message.get_encoded;
3055: hr_h2pi_error.data_error
3056: (p_from_id => v_ud_ppm.personal_payment_method_id,
3057: p_table_name => 'HR_H2PI_PAYMENT_METHODS',
3058: p_message_level => 'FATAL',
3059: p_message_text => l_encoded_message);
3060: COMMIT;
3061: RAISE;