DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_GRADE_RULES_F

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

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

Line 40: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

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

Line 41: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

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

Line 42: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

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

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

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

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

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

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

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

758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE

Line 763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE

Line 764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE

Line 765: ,p_rate_value IN pay_grade_rules_f.value%TYPE

761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --

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

762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE

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

763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE

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

764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE

Line 1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE

1455: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1456: --CWK
1457: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1458: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1460: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --

Line 1460: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE

1456: --CWK
1457: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1458: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1460: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'

Line 1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

1457: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1458: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1460: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

Line 1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

1458: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1460: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE