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_NL_WAGE_REPORT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 4297: FROM per_all_assignments_f asl

4293: ,c_tax_unit_id NUMBER
4294: ,c_paid_flag VARCHAR2) IS
4295: SELECT asl.assignment_id assignment_id
4296: ,paa.assignment_action_id assignment_action_id
4297: FROM per_all_assignments_f asl
4298: ,pay_all_payrolls_f ppf
4299: ,pay_payroll_actions ppa
4300: ,pay_assignment_actions paa
4301: ,per_time_periods ptp

Line 4332: FROM per_all_assignments_f asl

4328: AND prr.assignment_action_id = paa1.assignment_action_id))
4329: UNION
4330: SELECT asl.assignment_id assignment_id
4331: ,NULL assignment_action_id
4332: FROM per_all_assignments_f asl
4333: ,pay_all_payrolls_f ppf
4334: WHERE asl.person_id BETWEEN stperson AND endperson
4335: AND c_paid_flag = 'N'
4336: AND ppf.payroll_id = asl.payroll_id

Line 4399: ,per_all_assignments_f paaf

4395: ,paaf.primary_flag
4396: FROM pay_payroll_actions ppa
4397: ,pay_payroll_actions ppa1
4398: ,pay_assignment_actions paa
4399: ,per_all_assignments_f paaf
4400: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'
4401: AND ppa.report_qualifier = 'NL'
4402: AND ppa.action_type = 'X'
4403: AND ppa.action_status = 'C'

Line 4440: FROM per_all_assignments_f asl

4436: ,c_tax_unit_id NUMBER
4437: ,c_paid_flag VARCHAR2) IS
4438: SELECT DISTINCT asl.assignment_id assignment_id
4439: ,paa.assignment_action_id assignment_action_id
4440: FROM per_all_assignments_f asl
4441: ,pay_payroll_actions ppa
4442: ,pay_assignment_actions paa
4443: ,per_time_periods ptp
4444: WHERE asl.person_id BETWEEN stperson AND endperson and

Line 4466: FROM per_all_assignments_f asl

4462: AND prr.assignment_action_id = paa1.assignment_action_id))
4463: UNION
4464: SELECT asl.assignment_id assignment_id
4465: ,NULL assignment_action_id
4466: FROM per_all_assignments_f asl
4467: ,pay_all_payrolls_f ppf
4468: WHERE asl.person_id BETWEEN stperson AND endperson
4469: AND c_paid_flag = 'N'
4470: AND ppf.payroll_id = asl.payroll_id

Line 4595: ,per_all_assignments_f paaf

4591: CURSOR csr_assignment_actions(p_arc_pactid NUMBER) IS
4592: SELECT paa.assignment_action_id
4593: ,paa.assignment_id
4594: FROM pay_assignment_actions paa
4595: ,per_all_assignments_f paaf
4596: ,pay_payroll_actions ppa
4597: WHERE paa.payroll_action_id = p_arc_pactid
4598: AND paa.payroll_action_id = ppa.payroll_action_id
4599: AND paaf.person_id BETWEEN stperson

Line 5965: FROM per_all_assignments_f paaf

5961: ,paaf.soft_coding_keyflex_id
5962: ,paaf.assignment_status_type_id
5963: ,paaf.payroll_id
5964: ,paaf.primary_flag
5965: FROM per_all_assignments_f paaf
5966: ,per_all_people_f pap
5967: WHERE paaf.assignment_id = c_assignment_id
5968: AND paaf.person_id = pap.person_id
5969: AND c_effective_date BETWEEN paaf.effective_start_date

Line 5978: FROM per_all_assignments_f paaf

5974: /*CURSOR csr_emp_termination_date(c_assignment_id NUMBER) IS
5975: SELECT pps.date_start emp_start_date
5976: ,pps.actual_termination_date emp_termination_date
5977: ,paaf.primary_flag
5978: FROM per_all_assignments_f paaf
5979: ,per_periods_of_service pps
5980: WHERE paaf.assignment_id = c_assignment_id
5981: AND pps.person_id = paaf.person_id
5982: AND pps.period_of_service_id = paaf.period_of_service_id;*/

Line 6256: FROM per_all_assignments_F paaf

6252: --
6253: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
6254: SELECT min(effective_start_date)
6255: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
6256: FROM per_all_assignments_F paaf
6257: ,PER_ASSIGNMENT_STATUS_TYPES ast
6258: WHERE paaf.assignment_id = c_assignment_id
6259: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6260: AND ast.per_system_status = 'ACTIVE_ASSIGN';

Line 6264: FROM per_all_assignments_F paaf

6260: AND ast.per_system_status = 'ACTIVE_ASSIGN';
6261: --
6262: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
6263: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
6264: FROM per_all_assignments_F paaf
6265: ,PER_ASSIGNMENT_STATUS_TYPES ast
6266: WHERE paaf.assignment_id = c_assignment_id
6267: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6268: AND ast.per_system_status <> 'TERM_ASSIGN';

Line 6272: FROM per_all_assignments_F paaf

6268: AND ast.per_system_status <> 'TERM_ASSIGN';
6269: --
6270: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
6271: SELECT min(effective_start_date)
6272: FROM per_all_assignments_F paaf
6273: ,PER_ASSIGNMENT_STATUS_TYPES ast
6274: WHERE paaf.assignment_id = c_assignment_id
6275: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6276: AND ast.per_system_status = 'TERM_ASSIGN';

Line 6360: FROM per_all_assignments_f paaf

6356: --
6357: CURSOR get_scl_id(c_assignment_id NUMBER
6358: ,c_start_date DATE) IS
6359: SELECT paaf.soft_coding_keyflex_id
6360: FROM per_all_assignments_f paaf
6361: WHERE assignment_id = c_assignment_id
6362: AND c_start_date BETWEEN paaf.effective_start_date
6363: AND paaf.effective_end_date;
6364: --

Line 6368: FROM per_All_assignments_F

6364: --
6365: CURSOR csr_get_col_agreement_id (c_assignment_id NUMBER
6366: ,c_eff_date DATE) IS
6367: SELECT collective_agreement_id
6368: FROM per_All_assignments_F
6369: WHERE assignment_id = c_assignment_id
6370: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
6371: --
6372: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 6372: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

6368: FROM per_All_assignments_F
6369: WHERE assignment_id = c_assignment_id
6370: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
6371: --
6372: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6373: --
6374: l_initial_flag VARCHAR2(1);
6375: l_emp_seq per_all_Assignments_f.assignment_number%type;
6376: --

Line 6375: l_emp_seq per_all_Assignments_f.assignment_number%type;

6371: --
6372: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6373: --
6374: l_initial_flag VARCHAR2(1);
6375: l_emp_seq per_all_Assignments_f.assignment_number%type;
6376: --
6377: BEGIN
6378: --Fnd_file.put_line(FND_FILE.LOG,' Start chk_events');
6379: --Fnd_file.put_line(FND_FILE.LOG,' Assignment ID :'||p_assignment_id);

Line 7080: FROM per_all_assignments_f

7076: l_emp_rec.ASSIGNMENT_STATUS_TYPE_ID := l_rec_changes(i).new_value;
7077: ELSIF l_rec_changes(i).column_name = 'SOFT_CODING_KEYFLEX_ID' THEN
7078: SELECT soft_coding_keyflex_id
7079: INTO l_emp_rec.soft_coding_keyflex_id
7080: FROM per_all_assignments_f
7081: WHERE assignment_id = l_assignment_id
7082: AND l_rec_changes(i).effective_date BETWEEN effective_start_date AND effective_end_date;
7083: --
7084: --Fnd_file.put_line(FND_FILE.LOG,' Change in SCL New val :'||l_rec_changes(i).new_value);

Line 8408: FROM per_all_assignments_f paaf

8404: ,paaf.soft_coding_keyflex_id
8405: ,paaf.assignment_status_type_id
8406: ,paaf.payroll_id
8407: ,paaf.primary_flag
8408: FROM per_all_assignments_f paaf
8409: ,per_all_people_f pap
8410: WHERE paaf.assignment_id = c_assignment_id
8411: AND paaf.person_id = pap.person_id
8412: AND c_effective_date BETWEEN paaf.effective_start_date

Line 8543: FROM per_all_assignments_F paaf

8539: --
8540: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
8541: SELECT min(effective_start_date)
8542: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
8543: FROM per_all_assignments_F paaf
8544: ,PER_ASSIGNMENT_STATUS_TYPES ast
8545: WHERE paaf.assignment_id = c_assignment_id
8546: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8547: AND ast.per_system_status = 'ACTIVE_ASSIGN';

Line 8551: FROM per_all_assignments_F paaf

8547: AND ast.per_system_status = 'ACTIVE_ASSIGN';
8548: --
8549: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
8550: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
8551: FROM per_all_assignments_F paaf
8552: ,PER_ASSIGNMENT_STATUS_TYPES ast
8553: WHERE paaf.assignment_id = c_assignment_id
8554: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8555: AND ast.per_system_status <> 'TERM_ASSIGN';

Line 8559: FROM per_all_assignments_F paaf

8555: AND ast.per_system_status <> 'TERM_ASSIGN';
8556: --
8557: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
8558: SELECT min(effective_start_date)
8559: FROM per_all_assignments_F paaf
8560: ,PER_ASSIGNMENT_STATUS_TYPES ast
8561: WHERE paaf.assignment_id = c_assignment_id
8562: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8563: AND ast.per_system_status = 'TERM_ASSIGN';

Line 8636: FROM per_all_assignments_f paaf

8632: --
8633: CURSOR get_scl_id(c_assignment_id NUMBER
8634: ,c_start_date DATE) IS
8635: SELECT paaf.soft_coding_keyflex_id
8636: FROM per_all_assignments_f paaf
8637: WHERE assignment_id = c_assignment_id
8638: AND c_start_date BETWEEN paaf.effective_start_date
8639: AND paaf.effective_end_date;
8640: --

Line 8644: FROM per_All_assignments_F

8640: --
8641: CURSOR csr_get_col_agreement_id (c_assignment_id NUMBER
8642: ,c_eff_date DATE) IS
8643: SELECT collective_agreement_id
8644: FROM per_All_assignments_F
8645: WHERE assignment_id = c_assignment_id
8646: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
8647: --
8648: --

Line 8652: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

8648: --
8649: l_asg_id NUMBER;
8650: l_pay_act_id NUMBER;
8651: --
8652: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
8653: --
8654: l_initial_flag VARCHAR2(1);
8655: l_emp_seq per_all_Assignments_f.assignment_number%type;
8656: --

Line 8655: l_emp_seq per_all_Assignments_f.assignment_number%type;

8651: --
8652: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
8653: --
8654: l_initial_flag VARCHAR2(1);
8655: l_emp_seq per_all_Assignments_f.assignment_number%type;
8656: --
8657: BEGIN
8658: --Fnd_file.put_line(FND_FILE.LOG,' Start chk_events');
8659: --Fnd_file.put_line(FND_FILE.LOG,' Assignment ID :'||p_assignment_id);

Line 8916: l_assignment_id per_all_assignments_f.assignment_id%type;

8912: --------------------------------------------------------------------------------
8913: PROCEDURE archive_code (p_assactid in number,
8914: p_effective_date in date) IS
8915: --
8916: l_assignment_id per_all_assignments_f.assignment_id%type;
8917: l_business_group_id NUMBER;
8918: l_pactid NUMBER;
8919: l_end_date DATE;
8920: l_start_date DATE;