DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_GRADE_RULES_F

Line 46: ,grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE

42: ,po_header_id po_headers_all.po_header_id%TYPE
43: ,po_line_num po_lines_all.line_num%TYPE
44: ,po_line_id po_lines_all.po_line_id%TYPE
45: ,project_title per_all_assignments_f.project_title%type
46: ,grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
47: ,rate_id pay_grade_rules_f.rate_id%TYPE
48: ,rate_name pay_rates.name%TYPE
49: ,rate_basis pay_rates.rate_basis%TYPE
50: ,asg_rate_type_name fnd_lookups.meaning%TYPE

Line 47: ,rate_id pay_grade_rules_f.rate_id%TYPE

43: ,po_line_num po_lines_all.line_num%TYPE
44: ,po_line_id po_lines_all.po_line_id%TYPE
45: ,project_title per_all_assignments_f.project_title%type
46: ,grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
47: ,rate_id pay_grade_rules_f.rate_id%TYPE
48: ,rate_name pay_rates.name%TYPE
49: ,rate_basis pay_rates.rate_basis%TYPE
50: ,asg_rate_type_name fnd_lookups.meaning%TYPE
51: ,rate_currency fnd_currencies_vl.name%TYPE

Line 52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE

48: ,rate_name pay_rates.name%TYPE
49: ,rate_basis pay_rates.rate_basis%TYPE
50: ,asg_rate_type_name fnd_lookups.meaning%TYPE
51: ,rate_currency fnd_currencies_vl.name%TYPE
52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE
53: ,rate_value pay_grade_rules_f.value%TYPE
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

Line 53: ,rate_value pay_grade_rules_f.value%TYPE

49: ,rate_basis pay_rates.rate_basis%TYPE
50: ,asg_rate_type_name fnd_lookups.meaning%TYPE
51: ,rate_currency fnd_currencies_vl.name%TYPE
52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE
53: ,rate_value pay_grade_rules_f.value%TYPE
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --

Line 54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE

50: ,asg_rate_type_name fnd_lookups.meaning%TYPE
51: ,rate_currency fnd_currencies_vl.name%TYPE
52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE
53: ,rate_value pay_grade_rules_f.value%TYPE
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type

Line 55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

51: ,rate_currency fnd_currencies_vl.name%TYPE
52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE
53: ,rate_value pay_grade_rules_f.value%TYPE
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type

Line 56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

52: ,rate_currency_code pay_grade_rules_f.currency_code%TYPE
53: ,rate_value pay_grade_rules_f.value%TYPE
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type
60: ,age number