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.PAY_IN_UTILS dependencies on PAY_ELEMENT_LINKS_F

Line 1029: FROM pay_element_links_f

1025: location_id,
1026: pay_basis_id,
1027: employment_category,
1028: people_group_id
1029: FROM pay_element_links_f
1030: WHERE element_type_id = p_element_type_id
1031: and business_group_id = p_bg_id
1032: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1033:

Line 1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;

1059: AND element_link_id = p_element_link_id
1060: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1061:
1062:
1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;

Line 1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;

1060: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1061:
1062:
1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;

Line 1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;

1061:
1062:
1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;

Line 1066: l_link_org_id pay_element_links_f.organization_id%TYPE;

1062:
1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;

Line 1067: l_link_pos_id pay_element_links_f.position_id%TYPE;

1063: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;

Line 1068: l_link_job_id pay_element_links_f.job_id%TYPE;

1064: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;

Line 1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;

1065: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;

Line 1070: l_link_loc_id pay_element_links_f.location_id%TYPE;

1066: l_link_org_id pay_element_links_f.organization_id%TYPE;
1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1074:

Line 1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;

1067: l_link_pos_id pay_element_links_f.position_id%TYPE;
1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1074:
1075: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;

1068: l_link_job_id pay_element_links_f.job_id%TYPE;
1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1074:
1075: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;
1076: l_asg_org_id per_all_assignments_f.organization_id%TYPE;

Line 1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;

1069: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1070: l_link_loc_id pay_element_links_f.location_id%TYPE;
1071: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1072: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1073: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1074:
1075: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;
1076: l_asg_org_id per_all_assignments_f.organization_id%TYPE;
1077: l_asg_pos_id per_all_assignments_f.position_id%TYPE;

Line 1181: , pay_element_links_f link

1177: CURSOR csr_element_link_details
1178: IS
1179: SELECT link.element_link_id
1180: FROM per_assignments_f assgn
1181: , pay_element_links_f link
1182: , pay_element_types_f types
1183: WHERE assgn.assignment_id = p_assignment_id
1184: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR
1185: (link.link_to_all_payrolls_flag = 'Y' AND assgn.payroll_id IS NOT NULL) OR