eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_PERSON_UPLOAD dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2689: FROM pay_personal_payment_methods_f ppm

2685:
2686: CURSOR csr_ed_payment_method_ovn (p_ppm_id NUMBER,
2687: p_esd DATE) IS
2688: SELECT ppm.object_version_number
2689: FROM pay_personal_payment_methods_f ppm
2690: WHERE ppm.personal_payment_method_id = p_ppm_id
2691: AND p_esd BETWEEN ppm.effective_start_date
2692: AND ppm.effective_end_date;
2693:

Line 2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

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;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

Line 2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;

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;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:

Line 2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;

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;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

Line 2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;

2703: l_personal_pay_method_id
2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;

Line 2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;

Line 2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;

Line 2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;

2707: l_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

Line 2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;

2708: l_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;

Line 2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

2709:
2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
2717:

Line 2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;

2710: l_max_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
2717:
2718: l_records_same BOOLEAN;

Line 2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;

2711: l_del_ovn pay_personal_payment_methods_f.object_version_number%TYPE;
2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
2717:
2718: l_records_same BOOLEAN;
2719: l_future_records BOOLEAN;

Line 2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;

2712: l_del_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2713: l_del_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2714: l_val_esd pay_personal_payment_methods_f.effective_start_date%TYPE;
2715: l_val_eed pay_personal_payment_methods_f.effective_end_date%TYPE;
2716: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
2717:
2718: l_records_same BOOLEAN;
2719: l_future_records BOOLEAN;
2720: l_update_mode VARCHAR2(30);

Line 2723: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;

2719: l_future_records BOOLEAN;
2720: l_update_mode VARCHAR2(30);
2721: l_delete_mode VARCHAR2(30);
2722:
2723: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
2724: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
2725:
2726: --
2727: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;

Line 2724: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;

2720: l_update_mode VARCHAR2(30);
2721: l_delete_mode VARCHAR2(30);
2722:
2723: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
2724: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
2725:
2726: --
2727: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
2728: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;

Line 2727: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;

2723: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
2724: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
2725:
2726: --
2727: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
2728: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
2729: --
2730:
2731: BEGIN

Line 2728: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;

2724: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
2725:
2726: --
2727: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
2728: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
2729: --
2730:
2731: BEGIN
2732: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2742: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',

2738: IF v_ud_ppm.last_upd_date = g_eot THEN
2739:
2740: hr_utility.set_location(l_proc, 20);
2741: l_personal_pay_method_id := hr_h2pi_map.get_to_id
2742: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2743: p_from_id => v_ud_ppm.personal_payment_method_id,
2744: p_report_error => TRUE);
2745:
2746: hr_utility.set_location(l_proc, 30);

Line 2781: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',

2777: p_from_id => v_ud_ppm.org_payment_method_id,
2778: p_report_error => TRUE);
2779:
2780: l_personal_pay_method_id := hr_h2pi_map.get_to_id
2781: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2782: p_from_id => v_ud_ppm.personal_payment_method_id);
2783:
2784: --
2785: IF v_ud_ppm.payee_type = 'O' THEN

Line 2882: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',

2878: );
2879:
2880: hr_utility.set_location(l_proc, 90);
2881: hr_h2pi_map.create_id_mapping
2882: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
2883: p_from_id => v_ud_ppm.personal_payment_method_id,
2884: p_to_id => l_personal_pay_method_id);
2885: ELSE
2886:

Line 2923: FROM pay_personal_payment_methods_f ppm

2919: l_records_same := FALSE;
2920:
2921: SELECT MAX(ppm.effective_end_date)
2922: INTO l_max_eed
2923: FROM pay_personal_payment_methods_f ppm
2924: WHERE ppm.personal_payment_method_id = l_personal_pay_method_id;
2925:
2926: IF l_max_eed > v_ed_ppm.effective_end_date THEN
2927: hr_utility.set_location(l_proc, 130);

Line 3546: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',

3542: p_from_id => v_ud_ele.element_entry_id);
3543:
3544: IF v_ud_ele.personal_payment_method_id IS NOT NULL THEN
3545: l_ee_personal_pay_method_id := hr_h2pi_map.get_to_id
3546: (p_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
3547: p_from_id => v_ud_ele.personal_payment_method_id);
3548: ELSE
3549: l_ee_personal_pay_method_id := NULL;
3550: END IF;