DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_GRADE_RULES_F

Line 43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

39: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
40: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

Line 44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

40: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

Line 45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

Line 46: ,p_rate_value IN pay_grade_rules_f.value%TYPE

42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --

Line 47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE

Line 48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE

Line 49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE

Line 795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;

791: --
792: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --

Line 796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;

792: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;

Line 797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;

793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;
801: l_dummy_v VARCHAR2(240);

Line 798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;

794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;
801: l_dummy_v VARCHAR2(240);
802: l_dummy_d DATE;

Line 2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

Line 2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

Line 2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

Line 2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE

2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --

Line 2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE

Line 2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE

Line 2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE

Line 3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;

3493: --
3494: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --

Line 3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;

3494: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;

Line 3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;

3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3503: --

Line 3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;

3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3503: --
3504: l_gsp_post_process_warning varchar2(30); -- bug2999562

Line 7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE

7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --

Line 7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE

7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'

Line 7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

Line 7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE