DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_GRADE_RULES_F

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

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

Line 47: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

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

Line 48: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

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

Line 49: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

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

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

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

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

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

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

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

765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

Line 770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

Line 771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

Line 772: ,p_rate_value IN pay_grade_rules_f.value%TYPE

768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --

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

769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE

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

770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE

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

771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE
773: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776: --
777: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779: ,p_email_address IN per_all_people_f.email_address%TYPE

Line 1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE

1462: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1463: --CWK
1464: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1465: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1467: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --

Line 1467: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE

1463: --CWK
1464: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1465: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1467: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'

Line 1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

1464: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1465: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1467: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

Line 1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

1465: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1467: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE