[Home] [Help]
1327: begin
1328: select paa.assignment_id, paa.action_sequence, ppa.effective_date
1329: into l_assignment_id, l_action_sequence, l_assact_effdate
1330: from pay_assignment_actions paa,
1331: pay_payroll_actions ppa
1332: where paa.assignment_action_id = p_assignment_action_id
1333: and paa.payroll_action_id = ppa.payroll_action_id;
1334: exception
1335: when no_data_found then
1652: p_effective_date IN DATE ) IS
1653: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1654: paa.assignment_action_id),16))
1655: from pay_assignment_actions paa,
1656: pay_payroll_actions ppa,
1657: per_assignments_f paf
1658: where paa.assignment_id = p_assignment_id
1659: and paf.assignment_id = p_assignment_id
1660: and paf.assignment_id = paa.assignment_id
1706: BEGIN
1707: select TP.end_date + 1
1708: into l_return_val
1709: from per_time_periods TP,
1710: pay_payroll_actions PACT,
1711: pay_assignment_actions ASSACT
1712: where ASSACT.assignment_action_id = p_assactid
1713: and PACT.payroll_action_id = ASSACT.payroll_action_id
1714: and PACT.payroll_id = TP.payroll_id
1899:
1900: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1901: SELECT fnd_date.canonical_to_date(org_information11)
1902: INTO l_beg_of_fiscal_year
1903: FROM pay_payroll_actions PACT,
1904: pay_assignment_actions ASSACT,
1905: hr_organization_information HOI
1906: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1907: AND HOI.organization_id = PACT.business_group_id
1913:
1914: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1915: SELECT fnd_date.canonical_to_date(org_information11)
1916: INTO l_beg_of_fiscal_year
1917: FROM pay_payroll_actions PACT,
1918: pay_assignment_actions ASSACT,
1919: hr_organization_information HOI
1920: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1921: AND HOI.organization_id = PACT.business_group_id