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 7185: FROM per_all_assignments_f asl

7181: ,c_tax_unit_id NUMBER
7182: ,c_paid_flag VARCHAR2) IS
7183: SELECT asl.assignment_id assignment_id
7184: ,paa.assignment_action_id assignment_action_id
7185: FROM per_all_assignments_f asl
7186: ,pay_all_payrolls_f ppf
7187: ,pay_payroll_actions ppa
7188: ,pay_assignment_actions paa
7189: ,per_time_periods ptp

Line 7220: FROM per_all_assignments_f asl

7216: AND prr.assignment_action_id = paa1.assignment_action_id))
7217: UNION
7218: SELECT asl.assignment_id assignment_id
7219: ,NULL assignment_action_id
7220: FROM per_all_assignments_f asl
7221: ,pay_all_payrolls_f ppf
7222: WHERE asl.person_id BETWEEN stperson AND endperson
7223: AND c_paid_flag = 'N'
7224: AND ppf.payroll_id = asl.payroll_id

Line 7287: ,per_all_assignments_f paaf

7283: ,paaf.primary_flag
7284: FROM pay_payroll_actions ppa
7285: ,pay_payroll_actions ppa1
7286: ,pay_assignment_actions paa
7287: ,per_all_assignments_f paaf
7288: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'
7289: AND ppa.report_qualifier = 'NL'
7290: AND ppa.action_type = 'X'
7291: AND ppa.action_status = 'C'

Line 7328: FROM per_all_assignments_f asl

7324: ,c_tax_unit_id NUMBER
7325: ,c_paid_flag VARCHAR2) IS
7326: SELECT DISTINCT asl.assignment_id assignment_id
7327: ,paa.assignment_action_id assignment_action_id
7328: FROM per_all_assignments_f asl
7329: ,pay_payroll_actions ppa
7330: ,pay_assignment_actions paa
7331: ,per_time_periods ptp
7332: WHERE asl.person_id BETWEEN stperson AND endperson and

Line 7354: FROM per_all_assignments_f asl

7350: AND prr.assignment_action_id = paa1.assignment_action_id))
7351: UNION
7352: SELECT asl.assignment_id assignment_id
7353: ,NULL assignment_action_id
7354: FROM per_all_assignments_f asl
7355: ,pay_all_payrolls_f ppf
7356: WHERE asl.person_id BETWEEN stperson AND endperson
7357: AND c_paid_flag = 'N'
7358: AND ppf.payroll_id = asl.payroll_id

Line 7385: FROM per_all_assignments_f asl

7381: ,p_prev_corr_year VARCHAR2)
7382: IS
7383: SELECT asl.assignment_id assignment_id
7384: ,paa.assignment_action_id assignment_action_id
7385: FROM per_all_assignments_f asl
7386: ,pay_all_payrolls_f ppf
7387: ,pay_payroll_actions ppa
7388: ,pay_assignment_actions paa
7389: ,per_time_periods ptp

Line 7459: FROM per_all_assignments_f asl

7455: ) */ --10100628
7456: UNION
7457: SELECT asl.assignment_id assignment_id
7458: ,NULL assignment_action_id
7459: FROM per_all_assignments_f asl
7460: ,pay_all_payrolls_f ppf
7461: WHERE asl.person_id BETWEEN stperson AND endperson
7462: AND c_paid_flag = 'N'
7463: AND ppf.payroll_id = asl.payroll_id

Line 7622: ,per_all_assignments_f paaf

7618: CURSOR csr_assignment_actions(p_arc_pactid NUMBER) IS
7619: SELECT paa.assignment_action_id
7620: ,paa.assignment_id
7621: FROM pay_assignment_actions paa
7622: ,per_all_assignments_f paaf
7623: ,pay_payroll_actions ppa
7624: WHERE paa.payroll_action_id = p_arc_pactid
7625: AND paa.payroll_action_id = ppa.payroll_action_id
7626: AND paaf.person_id BETWEEN stperson

Line 9037: per_all_assignments_f paaf

9033: CURSOR csr_get_ass_bdate(c_assignment_id NUMBER) IS
9034: select papf.date_of_birth, TRUNC(MONTHS_BETWEEN(p_end_date,papf.date_of_birth)/12) Age
9035: from
9036: per_all_people_f papf,
9037: per_all_assignments_f paaf
9038: where paaf.assignment_id = c_assignment_id
9039: AND papf.person_id = paaf.person_id
9040: AND p_end_date between paaf.effective_start_date and paaf.effective_end_date
9041: AND p_end_date between papf.effective_start_date and papf.effective_end_date

Line 9633: FROM per_all_assignments_f paaf

9629: ,paaf.soft_coding_keyflex_id
9630: ,paaf.assignment_status_type_id
9631: ,paaf.payroll_id
9632: ,paaf.primary_flag
9633: FROM per_all_assignments_f paaf
9634: ,per_all_people_f pap
9635: WHERE paaf.assignment_id = c_assignment_id
9636: AND paaf.person_id = pap.person_id
9637: AND c_effective_date BETWEEN paaf.effective_start_date

Line 9646: FROM per_all_assignments_f paaf

9642: /*CURSOR csr_emp_termination_date(c_assignment_id NUMBER) IS
9643: SELECT pps.date_start emp_start_date
9644: ,pps.actual_termination_date emp_termination_date
9645: ,paaf.primary_flag
9646: FROM per_all_assignments_f paaf
9647: ,per_periods_of_service pps
9648: WHERE paaf.assignment_id = c_assignment_id
9649: AND pps.person_id = paaf.person_id
9650: AND pps.period_of_service_id = paaf.period_of_service_id;*/

Line 9925: FROM per_all_assignments_F paaf

9921: --
9922: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
9923: SELECT min(effective_start_date)
9924: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
9925: FROM per_all_assignments_F paaf
9926: ,PER_ASSIGNMENT_STATUS_TYPES ast
9927: WHERE paaf.assignment_id = c_assignment_id
9928: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9929: AND ast.per_system_status = 'ACTIVE_ASSIGN';

Line 9933: FROM per_all_assignments_F paaf

9929: AND ast.per_system_status = 'ACTIVE_ASSIGN';
9930: --
9931: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
9932: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
9933: FROM per_all_assignments_F paaf
9934: ,PER_ASSIGNMENT_STATUS_TYPES ast
9935: WHERE paaf.assignment_id = c_assignment_id
9936: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9937: AND ast.per_system_status <> 'TERM_ASSIGN';

Line 9941: FROM per_all_assignments_F paaf

9937: AND ast.per_system_status <> 'TERM_ASSIGN';
9938: --
9939: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
9940: SELECT min(effective_start_date)
9941: FROM per_all_assignments_F paaf
9942: ,PER_ASSIGNMENT_STATUS_TYPES ast
9943: WHERE paaf.assignment_id = c_assignment_id
9944: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9945: AND ast.per_system_status = 'TERM_ASSIGN';

Line 9986: FROM per_all_assignments_f asl

9982: ,c_business_group_id NUMBER
9983: ,c_tax_unit_id NUMBER
9984: ,c_payroll_type VARCHAR2) IS
9985: SELECT distinct asl.assignment_id assignment_id
9986: FROM per_all_assignments_f asl
9987: ,per_all_assignments_f asl2
9988: ,pay_all_payrolls_f ppf
9989: ,pay_payroll_actions ppa
9990: ,pay_assignment_actions paa

Line 9987: ,per_all_assignments_f asl2

9983: ,c_tax_unit_id NUMBER
9984: ,c_payroll_type VARCHAR2) IS
9985: SELECT distinct asl.assignment_id assignment_id
9986: FROM per_all_assignments_f asl
9987: ,per_all_assignments_f asl2
9988: ,pay_all_payrolls_f ppf
9989: ,pay_payroll_actions ppa
9990: ,pay_assignment_actions paa
9991: ,per_time_periods ptp

Line 10105: FROM per_all_assignments_f paaf

10101: --
10102: CURSOR get_scl_id(c_assignment_id NUMBER
10103: ,c_start_date DATE) IS
10104: SELECT paaf.soft_coding_keyflex_id
10105: FROM per_all_assignments_f paaf
10106: WHERE assignment_id = c_assignment_id
10107: AND c_start_date BETWEEN paaf.effective_start_date
10108: AND paaf.effective_end_date;
10109: --

Line 10113: FROM per_All_assignments_F

10109: --
10110: CURSOR csr_get_col_agreement_id (c_assignment_id NUMBER
10111: ,c_eff_date DATE) IS
10112: SELECT collective_agreement_id
10113: FROM per_All_assignments_F
10114: WHERE assignment_id = c_assignment_id
10115: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
10116: --
10117: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 10117: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

10113: FROM per_All_assignments_F
10114: WHERE assignment_id = c_assignment_id
10115: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
10116: --
10117: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
10118: --
10119: l_initial_flag VARCHAR2(1);
10120: l_emp_seq per_all_Assignments_f.assignment_number%type;
10121: --

Line 10120: l_emp_seq per_all_Assignments_f.assignment_number%type;

10116: --
10117: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
10118: --
10119: l_initial_flag VARCHAR2(1);
10120: l_emp_seq per_all_Assignments_f.assignment_number%type;
10121: --
10122: l_num_over_clash NUMBER:=0; /* 9764359 */
10123: l_arc_y_n VARCHAR2(1) := 'N'; --10100628
10124:

Line 11135: FROM per_all_assignments_f

11131: l_emp_rec.ASSIGNMENT_STATUS_TYPE_ID := l_rec_changes(i).new_value;
11132: ELSIF l_rec_changes(i).column_name = 'SOFT_CODING_KEYFLEX_ID' THEN
11133: SELECT soft_coding_keyflex_id
11134: INTO l_emp_rec.soft_coding_keyflex_id
11135: FROM per_all_assignments_f
11136: WHERE assignment_id = l_assignment_id
11137: AND l_rec_changes(i).effective_date BETWEEN effective_start_date AND effective_end_date;
11138: --
11139: --Fnd_file.put_line(FND_FILE.LOG,' Change in SCL New val :'||l_rec_changes(i).new_value);

Line 13997: FROM per_all_assignments_f paaf

13993: ,paaf.soft_coding_keyflex_id
13994: ,paaf.assignment_status_type_id
13995: ,paaf.payroll_id
13996: ,paaf.primary_flag
13997: FROM per_all_assignments_f paaf
13998: ,per_all_people_f pap
13999: WHERE paaf.assignment_id = c_assignment_id
14000: AND paaf.person_id = pap.person_id
14001: AND c_effective_date BETWEEN paaf.effective_start_date

Line 14133: FROM per_all_assignments_F paaf

14129: --
14130: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
14131: SELECT min(effective_start_date)
14132: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
14133: FROM per_all_assignments_F paaf
14134: ,PER_ASSIGNMENT_STATUS_TYPES ast
14135: WHERE paaf.assignment_id = c_assignment_id
14136: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14137: AND ast.per_system_status = 'ACTIVE_ASSIGN';

Line 14141: FROM per_all_assignments_F paaf

14137: AND ast.per_system_status = 'ACTIVE_ASSIGN';
14138: --
14139: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
14140: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
14141: FROM per_all_assignments_F paaf
14142: ,PER_ASSIGNMENT_STATUS_TYPES ast
14143: WHERE paaf.assignment_id = c_assignment_id
14144: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14145: AND ast.per_system_status <> 'TERM_ASSIGN';

Line 14149: FROM per_all_assignments_F paaf

14145: AND ast.per_system_status <> 'TERM_ASSIGN';
14146: --
14147: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
14148: SELECT min(effective_start_date)
14149: FROM per_all_assignments_F paaf
14150: ,PER_ASSIGNMENT_STATUS_TYPES ast
14151: WHERE paaf.assignment_id = c_assignment_id
14152: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14153: AND ast.per_system_status = 'TERM_ASSIGN';

Line 14184: FROM per_all_assignments_f asl

14180: ,c_end_date DATE
14181: ,c_business_group_id NUMBER
14182: ,c_tax_unit_id NUMBER) IS
14183: SELECT distinct asl.assignment_id assignment_id
14184: FROM per_all_assignments_f asl
14185: ,per_all_assignments_f asl2
14186: ,pay_payroll_actions ppa
14187: ,pay_assignment_actions paa
14188: ,per_time_periods ptp

Line 14185: ,per_all_assignments_f asl2

14181: ,c_business_group_id NUMBER
14182: ,c_tax_unit_id NUMBER) IS
14183: SELECT distinct asl.assignment_id assignment_id
14184: FROM per_all_assignments_f asl
14185: ,per_all_assignments_f asl2
14186: ,pay_payroll_actions ppa
14187: ,pay_assignment_actions paa
14188: ,per_time_periods ptp
14189: WHERE asl.person_id = asl2.person_id

Line 14291: FROM per_all_assignments_f paaf

14287: --
14288: CURSOR get_scl_id(c_assignment_id NUMBER
14289: ,c_start_date DATE) IS
14290: SELECT paaf.soft_coding_keyflex_id
14291: FROM per_all_assignments_f paaf
14292: WHERE assignment_id = c_assignment_id
14293: AND c_start_date BETWEEN paaf.effective_start_date
14294: AND paaf.effective_end_date;
14295: --

Line 14299: FROM per_All_assignments_F

14295: --
14296: CURSOR csr_get_col_agreement_id (c_assignment_id NUMBER
14297: ,c_eff_date DATE) IS
14298: SELECT collective_agreement_id
14299: FROM per_All_assignments_F
14300: WHERE assignment_id = c_assignment_id
14301: AND c_eff_date BETWEEN effective_start_date AND effective_end_date;
14302: --
14303: --

Line 14307: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

14303: --
14304: l_asg_id NUMBER;
14305: l_pay_act_id NUMBER;
14306: --
14307: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
14308: --
14309: l_initial_flag VARCHAR2(1);
14310: l_emp_seq per_all_Assignments_f.assignment_number%type;
14311: --

Line 14310: l_emp_seq per_all_Assignments_f.assignment_number%type;

14306: --
14307: l_scl_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
14308: --
14309: l_initial_flag VARCHAR2(1);
14310: l_emp_seq per_all_Assignments_f.assignment_number%type;
14311: --
14312: l_num_over_clash NUMBER:=0; /* 9764359 */
14313: BEGIN
14314: --Fnd_file.put_line(FND_FILE.LOG,' Start chk_events');

Line 14664: l_assignment_id per_all_assignments_f.assignment_id%type;

14660: --------------------------------------------------------------------------------
14661: PROCEDURE archive_code (p_assactid in number,
14662: p_effective_date in date) IS
14663: --
14664: l_assignment_id per_all_assignments_f.assignment_id%type;
14665: l_business_group_id NUMBER;
14666: l_pactid NUMBER;
14667: l_end_date DATE;
14668: l_start_date DATE;