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 1037: FROM pay_element_links_f

1033: location_id,
1034: pay_basis_id,
1035: employment_category,
1036: people_group_id
1037: FROM pay_element_links_f
1038: WHERE element_type_id = p_element_type_id
1039: AND business_group_id = p_bg_id
1040: AND (payroll_id = p_payroll_id OR payroll_id is null)
1041: AND (organization_id = p_organization_id OR organization_id is null)

Line 1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;

1076: AND element_link_id = p_element_link_id
1077: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1078:
1079:
1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;

Line 1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;

1077: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1078:
1079:
1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;

Line 1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;

1078:
1079:
1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;

Line 1083: l_link_org_id pay_element_links_f.organization_id%TYPE;

1079:
1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;

Line 1084: l_link_pos_id pay_element_links_f.position_id%TYPE;

1080: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;

Line 1085: l_link_job_id pay_element_links_f.job_id%TYPE;

1081: l_link_payroll_id pay_element_links_f.payroll_id%TYPE;
1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;

Line 1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;

1082: l_link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%TYPE;
1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;

Line 1087: l_link_loc_id pay_element_links_f.location_id%TYPE;

1083: l_link_org_id pay_element_links_f.organization_id%TYPE;
1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1091:

Line 1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;

1084: l_link_pos_id pay_element_links_f.position_id%TYPE;
1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1091:
1092: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;

1085: l_link_job_id pay_element_links_f.job_id%TYPE;
1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1091:
1092: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;
1093: l_asg_org_id per_all_assignments_f.organization_id%TYPE;

Line 1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;

1086: l_link_grd_id pay_element_links_f.grade_id%TYPE;
1087: l_link_loc_id pay_element_links_f.location_id%TYPE;
1088: l_link_pay_basis_id pay_element_links_f.pay_basis_id%TYPE;
1089: l_link_emp_catg_id pay_element_links_f.employment_category%TYPE;
1090: l_link_pep_grp_id pay_element_links_f.people_group_id%TYPE;
1091:
1092: l_asg_payroll_id per_all_assignments_f.payroll_id%TYPE;
1093: l_asg_org_id per_all_assignments_f.organization_id%TYPE;
1094: l_asg_pos_id per_all_assignments_f.position_id%TYPE;

Line 1196: , pay_element_links_f link

1192: CURSOR csr_element_link_details
1193: IS
1194: SELECT link.element_link_id
1195: FROM per_assignments_f assgn
1196: , pay_element_links_f link
1197: , pay_element_types_f types
1198: WHERE assgn.assignment_id = p_assignment_id
1199: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR
1200: (link.link_to_all_payrolls_flag = 'Y' AND assgn.payroll_id IS NOT NULL) OR