[Home] [Help]
897: select has.payroll_id,
898: nvl(has.formula_id,0)
899: into payid,
900: formula
901: from hr_assignment_sets has
902: where has.assignment_set_id = asetid;
903: --
904: payroll := (payid is not null);
905: --
1274: if l_prof_value is null or l_prof_value = 'Y' then
1275: l_hints := '/*+ use_nl(pac pop has pay_asg act)
1276: index(pac PAY_PAYROLL_ACTIONS_PK)
1277: rowid(pop)
1278: index(has HR_ASSIGNMENT_SETS_PK)
1279: index(pay_asg PER_ASSIGNMENTS_F_N12)
1280: index(act PAY_ASSIGNMENT_ACTIONS_N51) */ ';
1281: else
1282: l_hints := null;
1285:
1286: sqlstr := '
1287: select '|| case chkno when null then '' else l_hints end ||' act.assignment_id,
1288: act.assignment_action_id
1289: from hr_assignment_sets has,
1290: pay_population_ranges pop,
1291: per_all_assignments_f pay_asg,
1292: pay_payroll_actions pac,
1293: pay_assignment_actions act
1405: if(everyone) then
1406: sqlstr := '
1407: select pay_asg.assignment_id
1408: from per_all_assignments_f pay_asg,
1409: hr_assignment_sets has
1410: where has.assignment_set_id = :v_asg_set
1411: and pay_asg.payroll_id = has.payroll_id
1412: and fnd_date.canonical_to_date(:v_effective_date) between
1413: pay_asg.effective_start_date and pay_asg.effective_end_date';
1416: if(include) then
1417: sqlstr := '
1418: select pay_asg.assignment_id
1419: from per_all_assignments_f pay_asg,
1420: hr_assignment_sets has,
1421: hr_assignment_set_amendments amd
1422: where has.assignment_set_id = :asetid
1423: and amd.assignment_set_id = has.assignment_set_id
1424: and pay_asg.payroll_id + 0 = has.payroll_id
1431: if(exclude) then
1432: sqlstr := '
1433: select pay_asg.assignment_id
1434: from per_all_assignments_f pay_asg,
1435: hr_assignment_sets has
1436: where has.assignment_set_id = :asetid
1437: and pay_asg.payroll_id = has.payroll_id
1438: and fnd_date.canonical_to_date(:v_effective_date) between
1439: pay_asg.effective_start_date and pay_asg.effective_end_date
1503: sqlstr := '
1504: select pay_asg.assignment_id, pay_asg.assignment_number,
1505: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1506: from per_all_assignments_f pay_asg,
1507: hr_assignment_sets has,
1508: PAY_ELEMENT_SET_MEMBERS pesm,
1509: pay_element_types_f petf
1510: where pay_asg.business_group_id = :p_bgid
1511: and has.assignment_set_id = :pasetid
1537: sqlstr := '
1538: select pay_asg.assignment_id, pay_asg.assignment_number,
1539: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1540: from per_all_assignments_f pay_asg,
1541: hr_assignment_sets has,
1542: pay_element_types_f petf
1543: where pay_asg.business_group_id = :p_bgid
1544: and has.assignment_set_id = :pasetid
1545: and pay_asg.assignment_type = ''E''
1559: sqlstr := '
1560: select pay_asg.assignment_id, pay_asg.assignment_number,
1561: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1562: from per_all_assignments_f pay_asg,
1563: hr_assignment_sets has,
1564: hr_assignment_set_amendments amd,
1565: PAY_ELEMENT_SET_MEMBERS pesm,
1566: pay_element_types_f petf
1567: where pay_asg.business_group_id = :p_bgid
1596: sqlstr := '
1597: select pay_asg.assignment_id, pay_asg.assignment_number,
1598: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1599: from per_all_assignments_f pay_asg,
1600: hr_assignment_sets has,
1601: hr_assignment_set_amendments amd,
1602: pay_element_types_f petf
1603: where pay_asg.business_group_id = :p_bgid
1604: and has.assignment_set_id = :pasetid
1621: sqlstr := '
1622: select pay_asg.assignment_id, pay_asg.assignment_number,
1623: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1624: from per_all_assignments_f pay_asg,
1625: hr_assignment_sets has,
1626: PAY_ELEMENT_SET_MEMBERS pesm,
1627: pay_element_types_f petf
1628: where pay_asg.business_group_id = :p_bgid
1629: and has.assignment_set_id = :pasetid
1660: sqlstr := '
1661: select pay_asg.assignment_id, pay_asg.assignment_number,
1662: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1663: from per_all_assignments_f pay_asg,
1664: hr_assignment_sets has,
1665: pay_element_types_f petf
1666: where pay_asg.business_group_id = :p_bgid
1667: and has.assignment_set_id = :pasetid
1668: and pay_asg.assignment_type = ''E''
1780: sqlstr := '
1781: select pay_asg.assignment_id,
1782: pay_asg.payroll_id
1783: from per_all_assignments_f pay_asg,
1784: hr_assignment_sets has,
1785: per_quickpaint_invocations inv
1786: where inv.qp_invocation_id = :qp_invocation_id
1787: and has.assignment_set_id = inv.invocation_context
1788: and pay_asg.business_group_id = has.business_group_id
1795: sqlstr := '
1796: select pay_asg.assignment_id,
1797: pay_asg.payroll_id
1798: from per_all_assignments_f pay_asg,
1799: hr_assignment_sets has,
1800: hr_assignment_set_amendments amd,
1801: per_quickpaint_invocations inv
1802: where inv.qp_invocation_id = :qp_invocation_id
1803: and has.assignment_set_id = inv.invocation_context
2573: --
2574: select pac.assignment_set_id
2575: into l_asg_set_id
2576: from pay_payroll_actions pac,
2577: hr_assignment_sets has
2578: where pac.payroll_action_id = pactid
2579: and has.assignment_set_id = pac.assignment_set_id
2580: and has.formula_id is null;
2581: --