[Home] [Help]
892: select has.payroll_id,
893: nvl(has.formula_id,0)
894: into payid,
895: formula
896: from hr_assignment_sets has
897: where has.assignment_set_id = asetid;
898: --
899: payroll := (payid is not null);
900: --
1262: if(everyone) then
1263: sqlstr := '
1264: select act.assignment_id,
1265: act.assignment_action_id
1266: from hr_assignment_sets has,
1267: pay_population_ranges pop,
1268: per_all_assignments_f pay_asg,
1269: pay_payroll_actions pac,
1270: pay_assignment_actions act
1370: if(everyone) then
1371: sqlstr := '
1372: select pay_asg.assignment_id
1373: from per_all_assignments_f pay_asg,
1374: hr_assignment_sets has
1375: where has.assignment_set_id = :v_asg_set
1376: and pay_asg.payroll_id = has.payroll_id
1377: and fnd_date.canonical_to_date(:v_effective_date) between
1378: pay_asg.effective_start_date and pay_asg.effective_end_date';
1381: if(include) then
1382: sqlstr := '
1383: select pay_asg.assignment_id
1384: from per_all_assignments_f pay_asg,
1385: hr_assignment_sets has,
1386: hr_assignment_set_amendments amd
1387: where has.assignment_set_id = :asetid
1388: and amd.assignment_set_id = has.assignment_set_id
1389: and pay_asg.payroll_id + 0 = has.payroll_id
1396: if(exclude) then
1397: sqlstr := '
1398: select pay_asg.assignment_id
1399: from per_all_assignments_f pay_asg,
1400: hr_assignment_sets has
1401: where has.assignment_set_id = :asetid
1402: and pay_asg.payroll_id = has.payroll_id
1403: and fnd_date.canonical_to_date(:v_effective_date) between
1404: pay_asg.effective_start_date and pay_asg.effective_end_date
1468: sqlstr := '
1469: select pay_asg.assignment_id, pay_asg.assignment_number,
1470: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1471: from per_all_assignments_f pay_asg,
1472: hr_assignment_sets has,
1473: PAY_ELEMENT_SET_MEMBERS pesm,
1474: pay_element_types_f petf
1475: where pay_asg.business_group_id = :p_bgid
1476: and has.assignment_set_id = :pasetid
1502: sqlstr := '
1503: select pay_asg.assignment_id, pay_asg.assignment_number,
1504: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1505: from per_all_assignments_f pay_asg,
1506: hr_assignment_sets has,
1507: pay_element_types_f petf
1508: where pay_asg.business_group_id = :p_bgid
1509: and has.assignment_set_id = :pasetid
1510: and pay_asg.assignment_type = ''E''
1524: sqlstr := '
1525: select pay_asg.assignment_id, pay_asg.assignment_number,
1526: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1527: from per_all_assignments_f pay_asg,
1528: hr_assignment_sets has,
1529: hr_assignment_set_amendments amd,
1530: PAY_ELEMENT_SET_MEMBERS pesm,
1531: pay_element_types_f petf
1532: where pay_asg.business_group_id = :p_bgid
1561: sqlstr := '
1562: select pay_asg.assignment_id, pay_asg.assignment_number,
1563: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1564: from per_all_assignments_f pay_asg,
1565: hr_assignment_sets has,
1566: hr_assignment_set_amendments amd,
1567: pay_element_types_f petf
1568: where pay_asg.business_group_id = :p_bgid
1569: and has.assignment_set_id = :pasetid
1586: sqlstr := '
1587: select pay_asg.assignment_id, pay_asg.assignment_number,
1588: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1589: from per_all_assignments_f pay_asg,
1590: hr_assignment_sets has,
1591: PAY_ELEMENT_SET_MEMBERS pesm,
1592: pay_element_types_f petf
1593: where pay_asg.business_group_id = :p_bgid
1594: and has.assignment_set_id = :pasetid
1625: sqlstr := '
1626: select pay_asg.assignment_id, pay_asg.assignment_number,
1627: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1628: from per_all_assignments_f pay_asg,
1629: hr_assignment_sets has,
1630: pay_element_types_f petf
1631: where pay_asg.business_group_id = :p_bgid
1632: and has.assignment_set_id = :pasetid
1633: and pay_asg.assignment_type = ''E''
1745: sqlstr := '
1746: select pay_asg.assignment_id,
1747: pay_asg.payroll_id
1748: from per_all_assignments_f pay_asg,
1749: hr_assignment_sets has,
1750: per_quickpaint_invocations inv
1751: where inv.qp_invocation_id = :qp_invocation_id
1752: and has.assignment_set_id = inv.invocation_context
1753: and pay_asg.business_group_id = has.business_group_id
1760: sqlstr := '
1761: select pay_asg.assignment_id,
1762: pay_asg.payroll_id
1763: from per_all_assignments_f pay_asg,
1764: hr_assignment_sets has,
1765: hr_assignment_set_amendments amd,
1766: per_quickpaint_invocations inv
1767: where inv.qp_invocation_id = :qp_invocation_id
1768: and has.assignment_set_id = inv.invocation_context
2515: --
2516: select pac.assignment_set_id
2517: into l_asg_set_id
2518: from pay_payroll_actions pac,
2519: hr_assignment_sets has
2520: where pac.payroll_action_id = pactid
2521: and has.assignment_set_id = pac.assignment_set_id
2522: and has.formula_id is null;
2523: --