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 PER_ALL_ASSIGNMENTS_F

Line 1092: l_asg_payroll_id per_all_assignments_f.payroll_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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;

Line 1093: l_asg_org_id per_all_assignments_f.organization_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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;

Line 1094: l_asg_pos_id per_all_assignments_f.position_id%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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

Line 1095: l_asg_job_id per_all_assignments_f.job_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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;

Line 1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;

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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1100: l_bus_grp_id NUMBER;

Line 1097: l_asg_loc_id per_all_assignments_f.location_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;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1100: l_bus_grp_id NUMBER;
1101:

Line 1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

1094: l_asg_pos_id per_all_assignments_f.position_id%TYPE;
1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1100: l_bus_grp_id NUMBER;
1101:
1102:

Line 1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;

1095: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1096: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1097: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1098: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1099: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1100: l_bus_grp_id NUMBER;
1101:
1102:
1103: l_flag NUMBER;

Line 2487: per_all_assignments_f asg

2483: IS
2484: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2485: FROM per_contact_relationships relation,
2486: per_all_people_f ppf,
2487: per_all_assignments_f asg
2488: WHERE relation.contact_person_id = p_contact_person_id
2489: AND relation.person_id = ppf.person_id
2490: AND asg.person_id = ppf.person_id
2491: AND asg.assignment_id = p_asg_id