[Home] [Help]
1326: set_context( 'ASSIGNMENT_ACTION_ID', p_assignment_action_id );
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
1675: CURSOR get_latest_assactid( p_assignment_id IN NUMBER,
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
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
1739: and p_date between TP.start_date and TP.end_date;
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
1932: AND PACT.payroll_action_id = ASSACT.payroll_action_id
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
1946: AND PACT.payroll_action_id = ASSACT.payroll_action_id