[Home] [Help]
1620: p_assignment_id number
1621: ,p_effective_date date
1622: ) is
1623: select ASS.payroll_id
1624: from per_all_assignments_f ASS
1625: where ASS.assignment_id = p_assignment_id
1626: and p_effective_date between ASS.effective_start_date
1627: and ASS.effective_end_date;
1628: --
2083: CURSOR c_assignment_jur
2084: IS
2085: SELECT LOC.region_1
2086: from hr_locations_all LOC
2087: , per_all_assignments_f ASSIGN
2088: where p_effective_date BETWEEN ASSIGN.effective_start_date
2089: AND ASSIGN.effective_end_date
2090: and ASSIGN.assignment_id = p_asg_id
2091: and LOC.location_id = ASSIGN.location_id;
2111:
2112: CURSOR WCB_ACC_AT_STAT_INFO
2113: IS
2114: select hsck.SEGMENT9 wcb_account
2115: from per_all_assignments_f paaf,
2116: hr_soft_coding_keyflex hsck
2117: where paaf.assignment_id = p_asg_id
2118: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2119: and hsck.enabled_flag = 'Y'
2122:
2123: CURSOR RATE_CODE_STAT_INFO
2124: IS
2125: select hsck.SEGMENT10 rate_code
2126: from per_all_assignments_f paaf,
2127: hr_soft_coding_keyflex hsck
2128: where paaf.assignment_id = p_asg_id
2129: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2130: and p_effective_date BETWEEN paaf.effective_start_date
2134: IS
2135: select to_number(target.ORG_INFORMATION2)
2136: from hr_organization_information target
2137: ,hr_soft_coding_keyflex hsck
2138: ,per_all_assignments_f paaf
2139: where target.organization_id = nvl(p_tax_unit_id,nvl(hsck.segment1,nvl(hsck.segment2,hsck.segment3)))
2140: and target.ORG_INFORMATION1 = l_jur_code
2141: and target.org_information_context = 'Provincial Reporting Info.'
2142: and paaf.assignment_id = p_asg_id
2148: CURSOR C_ASSIGNMENT_JOB
2149: IS
2150: select JOB.name
2151: from per_jobs JOB
2152: , per_all_assignments_f ASSIGN
2153: where p_effective_date BETWEEN ASSIGN.effective_start_date
2154: AND ASSIGN.effective_end_date
2155: and ASSIGN.assignment_id = p_asg_id
2156: and JOB.job_id (+)= ASSIGN.job_id;
2335: cursor csr_bal_adj is
2336: select TBA.*
2337: ,ASG.payroll_id
2338: from pay_temp_balance_adjustments TBA
2339: ,per_all_assignments_f ASG
2340: where
2341: ASG.assignment_id = p_glbl_data_rec.assignment_id
2342: and TBA.adjustment_date between ASG.effective_start_date
2343: and ASG.effective_end_date
3478: --
3479: -- get bus grp id
3480: select distinct person_id,business_group_id
3481: into l_person_id,l_bus_grp_id
3482: from per_all_assignments_f
3483: where assignment_id = p_assignment_id;
3484:
3485: pay_core_utils.get_upgrade_status(p_bus_grp_id=> l_bus_grp_id,
3486: p_short_name=> 'SINGLE_BAL_TABLE',
4850: ,ASG.assignment_type
4851: ,ASG.business_group_id
4852: ,ASG.payroll_id
4853: ,ASG.effective_start_date
4854: from per_all_assignments_f ASG
4855: where p_assignment_id is not null
4856: and ASG.business_group_id + 0 = p_business_group_id
4857: and ASG.assignment_id = p_assignment_id
4858: and p_upload_date between ASG.effective_start_date
4863: ,ASG.assignment_type
4864: ,ASG.business_group_id
4865: ,ASG.payroll_id
4866: ,ASG.effective_start_date
4867: from per_all_assignments_f ASG
4868: where p_assignment_id is null
4869: and ASG.business_group_id + 0 = p_business_group_id
4870: and ASG.assignment_number = p_assignment_number
4871: and p_upload_date between ASG.effective_start_date
5594: select /*+ ORDERED
5595: INDEX(ASG PER_ASSIGNMENTS_F_PK)*/
5596: distinct ASG.assignment_id
5597: from pay_balance_batch_lines BL,
5598: per_all_assignments_f ASG
5599: where BL.batch_id = p_batch_id
5600: and BL.assignment_id = ASG.assignment_id
5601: and ASG.business_group_id = p_business_group_id
5602: and ASG.payroll_id + 0 = p_payroll_id
5930: select /*+ ORDERED
5931: INDEX(ASG PER_ASSIGNMENTS_F_PK)*/
5932: distinct ASG.assignment_id
5933: from pay_balance_batch_lines BL,
5934: per_all_assignments_f ASG
5935: where BL.batch_id = p_batch_id
5936: and BL.assignment_id = ASG.assignment_id
5937: and BL.batch_line_status = 'T'
5938: and ASG.business_group_id = p_business_group_id