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 1075: l_asg_payroll_id per_all_assignments_f.payroll_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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;

Line 1076: l_asg_org_id per_all_assignments_f.organization_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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;

Line 1077: l_asg_pos_id per_all_assignments_f.position_id%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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

Line 1078: l_asg_job_id per_all_assignments_f.job_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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;

Line 1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;

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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1083: l_bus_grp_id NUMBER;

Line 1080: l_asg_loc_id per_all_assignments_f.location_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;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1083: l_bus_grp_id NUMBER;
1084:

Line 1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

1077: l_asg_pos_id per_all_assignments_f.position_id%TYPE;
1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1083: l_bus_grp_id NUMBER;
1084:
1085:

Line 1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;

1078: l_asg_job_id per_all_assignments_f.job_id%TYPE;
1079: l_asg_grd_id per_all_assignments_f.grade_id%TYPE;
1080: l_asg_loc_id per_all_assignments_f.location_id%TYPE;
1081: l_asg_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1082: l_asg_emp_catg_id per_all_assignments_f.employment_category%TYPE;
1083: l_bus_grp_id NUMBER;
1084:
1085:
1086: l_flag NUMBER;

Line 2472: per_all_assignments_f asg

2468: IS
2469: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2470: FROM per_contact_relationships relation,
2471: per_all_people_f ppf,
2472: per_all_assignments_f asg
2473: WHERE relation.contact_person_id = p_contact_person_id
2474: AND relation.person_id = ppf.person_id
2475: AND asg.person_id = ppf.person_id
2476: AND asg.assignment_id = p_asg_id