APPS.PAY_NL_IZA_UPLOAD dependencies on PAY_NL_IZA_UPLD_STATUS

Line 182: from pay_nl_iza_upld_status piza

178: and asg.effective_start_date <= v_period_End_Date
179: and asg.effective_end_date >= v_period_Start_Date
180: )
181: and paa.organization_id in (select distinct piza.organization_id iza_org_id
182: from pay_nl_iza_upld_status piza
183: where piza.process_year_month = v_period_End_Date
184: AND lpad(piza.employer_number,3,'0') = l_rec_client_num
185: AND piza.business_group_id = p_business_group_id
186:

Line 195: from pay_nl_iza_upld_status piza

191: SELECT distinct pose.organization_id_child iza_org_id
192: FROM per_org_structure_elements pose
193: where pose.org_structure_version_id = v_org_struct_version_id
194: START WITH pose.organization_id_parent in (select distinct piza.organization_id
195: from pay_nl_iza_upld_status piza
196: where piza.process_year_month = v_period_End_Date
197: AND lpad(piza.employer_number,3,'0') = l_rec_client_num
198: AND piza.business_group_id = p_business_group_id
199: )

Line 209: from pay_nl_iza_upld_status piza

205: SELECT distinct pose.organization_id_child iza_org_id
206: FROM per_org_structure_elements pose
207: where pose.org_structure_version_id = v_org_struct_version_id
208: START WITH pose.organization_id_parent in (select distinct piza.organization_id
209: from pay_nl_iza_upld_status piza
210: where piza.process_year_month = v_period_End_Date
211: AND lpad(piza.employer_number,3,'0') = l_rec_client_num
212: AND piza.business_group_id = p_business_group_id
213: )

Line 239: FROM pay_nl_iza_upld_status piza1

235: minus
236:
237: SELECT
238: piza1.person_id
239: FROM pay_nl_iza_upld_status piza1
240: WHERE piza1.process_year_month = v_period_End_Date
241: AND lpad(piza1.employer_number,3,'0') = l_rec_client_num
242: AND piza1.business_group_id = p_business_group_id;
243:

Line 477: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID

473:
474: end if;
475:
476: l_process_status:='MISSING';
477: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID
478: ,ORGANIZATION_ID
479: ,EMPLOYER_NUMBER
480: ,SUB_EMPLOYER_NUMBER
481: ,PAYROLL_CENTER

Line 900: | PAY_NL_IZA_UPLD_STATUS table for Rejected and Processed|

896: | by calling the function iza_validation. |
897: | After validation it calls the wrapper procedure |
898: | create_batch_line to create a record in pay_batch_lines|
899: | It also creates the record in the table |
900: | PAY_NL_IZA_UPLD_STATUS table for Rejected and Processed|
901: | records. |
902: ----------------------------------------------------------------------*/
903:
904:

Line 1244: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID

1240: END IF;
1241:
1242:
1243: l_process_status:='PROCESSED';
1244: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID
1245: ,ORGANIZATION_ID
1246: ,EMPLOYER_NUMBER
1247: ,SUB_EMPLOYER_NUMBER
1248: ,PAYROLL_CENTER

Line 1292: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID

1288:
1289: select decode(l_reject_reason_code1,'00',decode(l_reject_reason_code2,'00',l_reject_reason_code3,l_reject_reason_code2),l_reject_reason_code1) into l_reject_code from dual;
1290: l_process_status:='REJECTED';
1291:
1292: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID
1293: ,ORGANIZATION_ID
1294: ,EMPLOYER_NUMBER
1295: ,SUB_EMPLOYER_NUMBER
1296: ,PAYROLL_CENTER

Line 1661: DELETE from PAY_NL_IZA_UPLD_STATUS pizas

1657: begin
1658: l_period_start_date := to_date(p_month_from,'MMYYYY');
1659: l_period_end_date := last_day(to_date(p_month_to,'MMYYYY'));
1660:
1661: DELETE from PAY_NL_IZA_UPLD_STATUS pizas
1662: WHERE pizas.process_year_month between l_period_start_date and l_period_end_date
1663: AND pizas.organization_id = p_employer_id
1664: AND pizas.business_group_id = p_business_group_id;
1665: