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.PSP_ENC_CREATE_LINES dependencies on PER_ALL_ASSIGNMENTS_F

Line 909: per_all_assignments_f paf,

905: paf.effective_end_date
906: FROM per_pay_proposals ppp,
907: pay_input_values_f piv,
908: per_pay_bases ppb,
909: per_all_assignments_f paf,
910: per_assignment_status_types past
911: WHERE paf.assignment_id =p_assignment_id
912: AND ( ppp.change_date BETWEEN paf.effective_start_date AND paf.effective_end_date
913: OR ppp.change_date = (SELECT MAX(ppp1.change_date)

Line 1604: per_all_assignments_f paf,

1600: 'Y',
1601: 0,
1602: NULL
1603: FROM per_time_periods ptp,
1604: per_all_assignments_f paf,
1605: per_assignment_status_types past
1606: WHERE ptp.payroll_id = p_payroll_id
1607: AND paf.assignment_id = p_assignment_id
1608: AND ptp.start_date <= paf.effective_end_date

Line 1621: FROM per_all_assignments_f paf

1617: ORDER BY 1, 4;
1618:
1619: CURSOR c_person_id IS
1620: SELECT paf.person_id
1621: FROM per_all_assignments_f paf
1622: WHERE paf.assignment_id =p_assignment_id
1623: AND ROWNUM=1;
1624:
1625: l_project_number pa_projects_all.segment1%TYPE;

Line 1706: FROM per_all_assignments_f

1702: l_max_end_date DATE;
1703:
1704: CURSOR asg_number_cur IS
1705: SELECT organization_id
1706: FROM per_all_assignments_f
1707: WHERE assignment_id = p_assignment_id
1708: AND payroll_id = p_payroll_id
1709: AND effective_end_date >= l_asg_start_date
1710: AND ROWNUM = 1;

Line 6795: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

6791: l_assignment_id NUMBER(15);
6792: l_payroll_id NUMBER(15);
6793: l_person_id NUMBER(15);
6794: l_organization_id NUMBER(15);
6795: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6796: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6797: l_full_name per_all_people_f.full_name%TYPE;
6798: l_organization_name hr_organization_units.name%TYPE;
6799: l_process_mode VARCHAR2(15);

Line 6957: FROM per_all_assignments_f

6953: CURSOR asg_number_cur (p_effective_date IN DATE) IS
6954: SELECT assignment_number,
6955: person_id,
6956: organization_id
6957: FROM per_all_assignments_f
6958: WHERE assignment_id = l_assignment_id
6959: AND payroll_id = l_payroll_id
6960: AND effective_end_date >= p_effective_date
6961: AND ROWNUM = 1;

Line 7046: TYPE payid_tab IS TABLE OF per_all_assignments_f.payroll_id%TYPE INDEX BY BINARY_INTEGER;

7042: WHERE piv.input_value_id = pee.input_value_id
7043: AND SUBSTR(piv.uom, 1, 1) = 'H'));
7044:
7045:
7046: TYPE payid_tab IS TABLE OF per_all_assignments_f.payroll_id%TYPE INDEX BY BINARY_INTEGER;
7047: TYPE asgid_tab IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;
7048: TYPE term_date_tab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
7049: TYPE t_asg_id_rec IS RECORD
7050: (payroll_array payid_tab,

Line 7047: TYPE asgid_tab IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;

7043: AND SUBSTR(piv.uom, 1, 1) = 'H'));
7044:
7045:
7046: TYPE payid_tab IS TABLE OF per_all_assignments_f.payroll_id%TYPE INDEX BY BINARY_INTEGER;
7047: TYPE asgid_tab IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;
7048: TYPE term_date_tab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
7049: TYPE t_asg_id_rec IS RECORD
7050: (payroll_array payid_tab,
7051: asg_array asgid_tab,

Line 8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

8801: l_payroll_action_id NUMBER(15);
8802: l_payroll_id NUMBER(15);
8803: l_person_id NUMBER(15);
8804: l_organization_id NUMBER(15);
8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8807: l_full_name per_all_people_f.full_name%TYPE;
8808: l_organization_name hr_organization_units.name%TYPE;
8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;

Line 8874: FROM per_all_assignments_f

8870: CURSOR asg_number_cur (p_start_date IN DATE) IS
8871: SELECT assignment_number,
8872: person_id,
8873: organization_id
8874: FROM per_all_assignments_f
8875: WHERE assignment_id = l_assignment_id
8876: AND payroll_id = NVL(l_payroll_id, p_payroll_id)
8877: AND effective_end_date >= p_start_date
8878: AND ROWNUM = 1;

Line 8964: ,per_all_assignments_f paaf

8960: NO_USE_MERGE(paaf) */
8961: DISTINCT
8962: paaf.assignment_id
8963: FROM psp_enc_payrolls pep
8964: ,per_all_assignments_f paaf
8965: WHERE pep.inc_exc_flag = 'N'
8966: AND pep.payroll_id = paaf.payroll_id
8967: AND pep.payroll_id = p_payroll_id
8968: AND pep.business_group_id = p_business_group_id

Line 10100: per_all_assignments_f paf

10096: CURSOR asg_cur (p_person_id IN NUMBER,
10097: p_assignment_id IN NUMBER) IS
10098: SELECT DISTINCT pepa.assignment_id
10099: FROM psp_enc_process_assignments pepa,
10100: per_all_assignments_f paf
10101: WHERE pepa.payroll_action_id = p_payroll_action_id
10102: AND paf.person_id = p_person_id
10103: AND paf.assignment_id = pepa.assignment_id
10104: AND ( p_assignment_id IS NULL