[Home] [Help]
20: each currency.
21: --
22: MODIFIED DD-MON-YYYY
23: 115.50 pparate 29-AUG-2012 Modified code to insert null instead of
24: 0 in pay_gl_interface and gl_interface
25: tables for other side of Dr/Cr value.
26: Bug 14528715
27: 115.49 pparate 26-FEB-2009 Added change to query in procedure
28: trans_pay_costs_mt for better perf.
1020: pay_payroll_actions ppa1, -- Cost pay actions
1021: (select distinct
1022: gl.assignment_action_id,
1023: run_payroll_action_id
1024: from pay_gl_interface gl,
1025: pay_assignment_actions aa
1026: where gl.assignment_action_id = aa.assignment_action_id
1027: and aa.payroll_action_id = i_action_id) gl
1028: -- Checking with GL 6848762*/
1243: and ppa2.payroll_action_id = c_run_action_id;
1244:
1245: else
1246: -- estimate costs : nb accounting_date for reversal
1247: -- costs overriden by contents of pay_gl_interface.accouting_date
1248: --
1249: select ppa1.effective_date, ppa1.effective_date
1250: into c_accounting_date, c_run_date
1251: from pay_payroll_actions ppa1 -- Estimate Cost pay action
1372: entered_cr)
1373: SELECT /*+ ORDERED
1374: INDEX(paf PER_ASSIGNMENTS_F_PK)
1375: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1376: INDEX(pgl PAY_GL_INTERFACE_N1)
1377: USE_NL(pgl int pa pa2 paf) */
1378: ''NEW'',
1379: :c_set_of_books_id,
1380: :c_set_of_books_id,
1400: FROM pay_assignment_actions pa,
1401: '|| l_asg_tab ||'
1402: pay_action_interlocks int,
1403: pay_assignment_actions pa2,
1404: pay_gl_interface pgl,
1405: pay_cost_allocation_keyflex caf
1406: WHERE pgl.run_payroll_action_id = :c_run_action_id
1407: '|| l_asg_join ||'
1408: AND caf.cost_allocation_keyflex_id (+) = pgl.cost_allocation_keyflex_id
1442: entered_cr)
1443: SELECT /*+ ORDERED
1444: INDEX(paf PER_ASSIGNMENTS_F_PK)
1445: INDEX(int PAY_ACTION_INTERLOCKS_PK)
1446: INDEX(pgl PAY_GL_INTERFACE_N1)
1447: USE_NL(pgl int pa pa2 paf) */
1448: ''NEW'',
1449: :c_set_of_books_id,
1450: :l_source_name,
1469: FROM pay_assignment_actions pa,
1470: '|| l_asg_tab ||'
1471: pay_action_interlocks int,
1472: pay_assignment_actions pa2,
1473: pay_gl_interface pgl,
1474: pay_cost_allocation_keyflex caf
1475: WHERE pgl.run_payroll_action_id = :c_run_action_id
1476: '|| l_asg_join ||'
1477: AND caf.cost_allocation_keyflex_id (+) = pgl.cost_allocation_keyflex_id
1626: AND ppa2.action_type NOT IN ('C', 'S', 'EC');
1627: --
1628: hr_utility.set_location('pytrgl.trans_ass_costs',30);
1629: --
1630: INSERT INTO pay_gl_interface
1631: ( assignment_action_id,
1632: run_payroll_action_id,
1633: cost_allocation_keyflex_id,
1634: currency_code,
1837: AND ptp.end_date;
1838: --
1839: hr_utility.set_location('pytrgl.trans_ass_costs',50);
1840: --
1841: INSERT INTO pay_gl_interface
1842: ( assignment_action_id,
1843: run_payroll_action_id,
1844: cost_allocation_keyflex_id,
1845: currency_code,
1923: else
1924: --
1925: -- Payment Costing processes
1926: --
1927: INSERT INTO pay_gl_interface
1928: ( assignment_action_id,
1929: run_payroll_action_id,
1930: cost_allocation_keyflex_id,
1931: currency_code,