eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 81: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type; -- Global to store last archive payroll action id

77:
78: ====================================================================
79: */
80:
81: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type; -- Global to store last archive payroll action id
82:
83: g_package constant varchar2(60) := 'pay_au_payslip_archive.'; -- Global to store package name for tracing.
84:
85: --------------------------------------------------------------------

Line 93: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

89: --
90: --------------------------------------------------------------------
91:
92: procedure range_code
93: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
94: ,p_sql out NOCOPY varchar2
95: ) is
96:
97: l_procedure varchar2(200) ;

Line 123: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

119: --
120: --------------------------------------------------------------------
121:
122: procedure initialization_code
123: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
124: is
125: l_procedure varchar2(200) ;
126:
127: begin

Line 159: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

155: --
156: --------------------------------------------------------------------
157:
158: procedure assignment_action_code
159: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
160: ,p_start_person in per_all_people_f.person_id%type
161: ,p_end_person in per_all_people_f.person_id%type
162: ,p_chunk in number
163: ) is

Line 194: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

190: --------------------------------------------------------------------
191:
192: procedure archive_stat_elements
193: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type
194: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
195: ,p_assignment_id in pay_assignment_actions.assignment_id%type
196: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
197: ) is
198:

Line 287: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

283: */
284:
285: procedure archive_balances
286: (p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
287: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
288: ,p_narrative in varchar2
289: ,p_ytd in number
290: ,p_tp in number --Bug 3891564
291: ) is

Line 331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

327: --------------------------------------------------------------------
328:
329: procedure archive_stat_balances
330: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
332: ,p_assignment_id in pay_assignment_actions.assignment_id%type
333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
334: ,p_calculation_date in pay_payroll_actions.effective_date%type
335: ) is

Line 334: ,p_calculation_date in pay_payroll_actions.effective_date%type

330: (p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type /*4363057*/
331: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
332: ,p_assignment_id in pay_assignment_actions.assignment_id%type
333: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
334: ,p_calculation_date in pay_payroll_actions.effective_date%type
335: ) is
336: l_gross_this_pay number;
337: l_other_deductions_this_pay number;
338: l_tax_deductions_this_pay number;

Line 527: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

523: ---------------------------------------------------------------------------
524:
525: procedure archive_accruals
526: (p_assignment_id in pay_assignment_actions.assignment_id%type
527: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
528: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
529: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
530: ,p_calculation_date in date
531: ) is

Line 556: , pay_payroll_actions pa

552: , pay_element_types_f et
553: , pay_element_links_f el
554: , pay_element_entries_f ee
555: , pay_assignment_actions aa
556: , pay_payroll_actions pa
557: where et.element_type_id = ap.accrual_plan_element_type_id -- select the accrual plan elements
558: and el.element_type_id = et.element_type_id -- select accrual plan element entries
559: and aa.assignment_id = ee.assignment_id -- select element entries for this assignment
560: and ee.element_link_id = el.element_link_id -- join element to element entries via element links

Line 651: ,p_pre_effective_date in pay_payroll_actions.effective_date%type

647: into pay_action_information */
648:
649: procedure archive_absences
650: (p_assignment_id in pay_assignment_actions.assignment_id%type
651: ,p_pre_effective_date in pay_payroll_actions.effective_date%type
652: ,p_time_period_id in per_time_periods.time_period_id%type
653: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type
654: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type
655: ) is

Line 1149: pay_payroll_actions ppa_run

1145: and exists (
1146: select ''
1147: from pay_run_types_f prt,
1148: pay_assignment_actions paa_run,
1149: pay_payroll_actions ppa_run
1150: where paa_run.assignment_action_id
1151: = ppp.source_action_id
1152: and paa_run.payroll_action_id
1153: = ppa_run.payroll_action_id

Line 1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run

1306: (p_assignment_id in pay_assignment_actions.assignment_id%type
1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1313: ,p_time_period_id in per_time_periods.time_period_id%type
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */

Line 1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run

1307: ,p_arc_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for archive run
1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1313: ,p_time_period_id in per_time_periods.time_period_id%type
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/

Line 1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type

1308: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for payroll run
1309: ,p_pre_assignment_action_id in pay_assignment_actions.assignment_action_id%type -- assignment action for prepayment run
1310: ,p_pre_effective_date in pay_payroll_actions.effective_date%type -- effective date of prepayment run
1311: ,p_run_effective_date in pay_payroll_actions.effective_date%type -- effective date of payroll run
1312: ,p_run_date_earned in pay_payroll_actions.date_earned%type
1313: ,p_time_period_id in per_time_periods.time_period_id%type
1314: ,p_period_end_date in per_time_periods.end_date%type /* Bug No : 2491444 */
1315: ,p_regular_payment_date in per_time_periods.regular_payment_date%type /* Bug# 5681819*/
1316: ) is

Line 1320: l_date_earned pay_payroll_actions.date_earned%type;

1316: ) is
1317:
1318: l_action_info_id pay_action_information.action_information_id%type;
1319: l_ovn pay_action_information.object_version_number%type;
1320: l_date_earned pay_payroll_actions.date_earned%type;
1321: l_procedure varchar2(80) ;
1322: l_abn number;
1323: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1324:

Line 1338: ,p_effective_date pay_payroll_actions.effective_date%type

1334: --
1335: /*Bug2920725 Corrected base tables to support security model*/
1336: cursor csr_abn
1337: (p_assignment_id pay_assignment_actions.assignment_id%type
1338: ,p_effective_date pay_payroll_actions.effective_date%type
1339: ) is
1340: select org.org_information12 abn
1341: from per_assignments_f paaf
1342: , hr_soft_coding_keyflex flex

Line 1366: p_run_date_earned pay_payroll_actions.date_earned%type,

1362: /* Bug 5504354 - Added cursor to get pay_advice_date */
1363: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1364: ptp.default_dd_date is null use effective date of Pre Payment */
1365: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1366: p_run_date_earned pay_payroll_actions.date_earned%type,
1367: p_pre_effective_date pay_payroll_actions.effective_date%type)
1368: is
1369: select nvl(ptp.default_dd_date,p_pre_effective_date)
1370: from pay_payroll_actions ppa,

Line 1367: p_pre_effective_date pay_payroll_actions.effective_date%type)

1363: /* Bug 6032985 - Added ptp.default_dd_date in place of pay_advice_date ,in case where
1364: ptp.default_dd_date is null use effective date of Pre Payment */
1365: cursor csr_pay_advice_date(p_run_assignment_action_id pay_assignment_actions.assignment_action_id%type ,
1366: p_run_date_earned pay_payroll_actions.date_earned%type,
1367: p_pre_effective_date pay_payroll_actions.effective_date%type)
1368: is
1369: select nvl(ptp.default_dd_date,p_pre_effective_date)
1370: from pay_payroll_actions ppa,
1371: per_time_periods ptp,

Line 1370: from pay_payroll_actions ppa,

1366: p_run_date_earned pay_payroll_actions.date_earned%type,
1367: p_pre_effective_date pay_payroll_actions.effective_date%type)
1368: is
1369: select nvl(ptp.default_dd_date,p_pre_effective_date)
1370: from pay_payroll_actions ppa,
1371: per_time_periods ptp,
1372: pay_assignment_actions paa
1373: where p_run_date_earned between ptp.start_date and ptp.end_date
1374: and paa.assignment_action_id=p_run_assignment_action_id

Line 1390: ,p_effective_date pay_payroll_actions.effective_date%type,

1386:
1387: /* Bug 5504354 - Cursor c_grade_step added to get the grade step of an assignment */
1388:
1389: cursor c_grade_step(p_assignment_id pay_assignment_actions.assignment_id%type
1390: ,p_effective_date pay_payroll_actions.effective_date%type,
1391: p_business_group_id per_all_assignments_f.business_group_id%type
1392: ) is
1393: select count(*)
1394: from per_spinal_point_steps_f psp,

Line 1653: ,p_effective_date in pay_payroll_actions.effective_date%type

1649: --
1650: ----------------------------
1651: procedure archive_code
1652: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1653: ,p_effective_date in pay_payroll_actions.effective_date%type
1654: ) is
1655:
1656: cursor get_payslip_aa(p_master_aa_id number)
1657: is

Line 1673: pay_payroll_actions ppa_pre,

1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,
1674: pay_payroll_actions ppa_run,
1675: per_time_periods ptp
1676: where paa_arch_mst.assignment_action_id = p_master_aa_id
1677: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 1674: pay_payroll_actions ppa_run,

1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,
1674: pay_payroll_actions ppa_run,
1675: per_time_periods ptp
1676: where paa_arch_mst.assignment_action_id = p_master_aa_id
1677: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1678: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id