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_CORE_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 61: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type

57: -- Caches for get_entry_end_date
58: --
59: type t_proration_group_id is table of pay_element_types_f.proration_group_id%type
60: index by binary_integer;
61: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
62: index by binary_integer;
63: type t_date is table of date
64: index by binary_integer;
65: g_proration_group_id t_proration_group_id;

Line 82: token_val pay_payroll_actions.legislative_parameters%type;

78: parameter_list varchar2) return varchar2
79: is
80: start_ptr number;
81: end_ptr number;
82: token_val pay_payroll_actions.legislative_parameters%type;
83: par_value pay_payroll_actions.legislative_parameters%type;
84: separator varchar2(1) := ' ';
85: begin
86: --

Line 83: par_value pay_payroll_actions.legislative_parameters%type;

79: is
80: start_ptr number;
81: end_ptr number;
82: token_val pay_payroll_actions.legislative_parameters%type;
83: par_value pay_payroll_actions.legislative_parameters%type;
84: separator varchar2(1) := ' ';
85: begin
86: --
87: token_val := name||'=';

Line 135: token_val pay_payroll_actions.legislative_parameters%type;

131: end_space number; /* Pos of space after value */
132: full_ptr number; /* Full length of orig string */
133:
134:
135: token_val pay_payroll_actions.legislative_parameters%type;
136: l_parameter_list pay_payroll_actions.legislative_parameters%type;
137:
138: begin
139: --

Line 136: l_parameter_list pay_payroll_actions.legislative_parameters%type;

132: full_ptr number; /* Full length of orig string */
133:
134:
135: token_val pay_payroll_actions.legislative_parameters%type;
136: l_parameter_list pay_payroll_actions.legislative_parameters%type;
137:
138: begin
139: --
140: token_val := p_name||'=';

Line 358: pay_payroll_actions ppa,

354: into l_asg_id,
355: l_bus_grp_id,
356: l_leg_code
357: from pay_assignment_actions paa,
358: pay_payroll_actions ppa,
359: per_business_groups_perf pbg
360: where paa.assignment_action_id = p_asg_act_id
361: and ppa.business_group_id = pbg.business_group_id
362: and paa.payroll_action_id = ppa.payroll_action_id;

Line 421: pay_payroll_actions ppa

417: --
418: select ptp.start_date
419: into l_start_date
420: from per_time_periods ptp,
421: pay_payroll_actions ppa
422: where ppa.payroll_action_id = p_payroll_action_id
423: and ppa.payroll_id = ptp.payroll_id
424: and ppa.date_earned between ptp.start_date
425: and ptp.end_date;

Line 578: from pay_payroll_actions ppa,

574: into l_date_earned,
575: l_prd_end_date,
576: l_prd_start_date,
577: l_prorate_grp_id
578: from pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp,
581: pay_element_types_f pet
582: where paa.assignment_action_id = p_asg_act_id

Line 870: pay_payroll_actions ppa

866: select INTLK.locking_action_id
867: into l_action_id
868: from pay_action_interlocks INTLK,
869: pay_assignment_actions paa,
870: pay_payroll_actions ppa
871: where INTLK.locked_action_id = p_action_id
872: and INTLK.locking_action_id = paa.assignment_action_id
873: and paa.payroll_action_id = ppa.payroll_action_id
874: and ppa.action_type in ('P', 'U')

Line 975: pay_payroll_actions ppa

971: into l_run_method
972: from pay_run_types_f prt_aa,
973: pay_run_types_f prt_pa,
974: pay_assignment_actions paa,
975: pay_payroll_actions ppa
976: where paa.assignment_action_id = p_calling_action_id
977: and paa.payroll_action_id = ppa.payroll_action_id
978: and paa.run_type_id = prt_aa.run_type_id (+)
979: and ppa.effective_date between nvl(prt_aa.effective_start_date, ppa.effective_date)

Line 1096: pay_payroll_actions ppa

1092: select parameter_value
1093: into p_para_value
1094: from pay_report_format_parameters prfp,
1095: pay_report_format_mappings_f prfm,
1096: pay_payroll_actions ppa
1097: where ppa.payroll_action_id = p_payroll_action_id
1098: and ppa.report_type = prfm.report_type
1099: and ppa.report_qualifier = prfm.report_qualifier
1100: and ppa.report_category = prfm.report_category

Line 1694: l_eff_date pay_payroll_actions.effective_date%type;

1690: 'S', 1,
1691: 2);
1692: --
1693: l_run_meth pay_run_types_f.run_method%type;
1694: l_eff_date pay_payroll_actions.effective_date%type;
1695: l_ee_id pay_run_results.source_id%type;
1696: --
1697: begin
1698: --

Line 1705: pay_payroll_actions ppa

1701: into l_run_meth,
1702: l_eff_date
1703: from pay_run_types_f prt,
1704: pay_assignment_actions paa,
1705: pay_payroll_actions ppa
1706: where paa.assignment_action_id = p_asg_action_id
1707: and ppa.payroll_action_id = paa.payroll_action_id
1708: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)
1709: and ppa.effective_date

Line 2135: from pay_payroll_actions ppa,

2131: begin
2132:
2133: select ppf.payroll_name
2134: into l_payroll_name
2135: from pay_payroll_actions ppa,
2136: pay_payrolls_f ppf
2137: where ppa.payroll_action_id=p_pactid
2138: and nvl(ppa.payroll_id,-9999)=ppf.payroll_id
2139: and ppa.effective_date between ppf.effective_start_date and effective_end_date;

Line 2168: pay_payroll_actions ppa,

2164: if (g_leg_code is null) then
2165: select pbg.legislation_code
2166: into g_leg_code
2167: from pay_assignment_actions paa,
2168: pay_payroll_actions ppa,
2169: per_business_groups_perf pbg
2170: where paa.assignment_action_id = p_asg_act_id
2171: and ppa.business_group_id = pbg.business_group_id
2172: and paa.payroll_action_id = ppa.payroll_action_id;