[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
1676: p_effective_date IN DATE ) IS
1677: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1678: paa.assignment_action_id),16))
1679: from pay_assignment_actions paa,
1680: pay_payroll_actions ppa,
1681: per_assignments_f paf
1682: where paa.assignment_id = p_assignment_id
1683: and paf.assignment_id = p_assignment_id
1684: and paf.assignment_id = paa.assignment_id
1730: BEGIN
1731: select TP.end_date + 1
1732: into l_return_val
1733: from per_time_periods TP,
1734: pay_payroll_actions PACT,
1735: pay_assignment_actions ASSACT
1736: where ASSACT.assignment_action_id = p_assactid
1737: and PACT.payroll_action_id = ASSACT.payroll_action_id
1738: and PACT.payroll_id = TP.payroll_id
1923:
1924: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1925: SELECT fnd_date.canonical_to_date(org_information11)
1926: INTO l_beg_of_fiscal_year
1927: FROM pay_payroll_actions PACT,
1928: pay_assignment_actions ASSACT,
1929: hr_organization_information HOI
1930: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1931: AND HOI.organization_id = PACT.business_group_id
1937:
1938: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1939: SELECT fnd_date.canonical_to_date(org_information11)
1940: INTO l_beg_of_fiscal_year
1941: FROM pay_payroll_actions PACT,
1942: pay_assignment_actions ASSACT,
1943: hr_organization_information HOI
1944: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1945: AND HOI.organization_id = PACT.business_group_id