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 450: pay_payroll_actions ppa,

446: into l_asg_id,
447: l_bus_grp_id,
448: l_leg_code
449: from pay_assignment_actions paa,
450: pay_payroll_actions ppa,
451: per_business_groups_perf pbg
452: where paa.assignment_action_id = p_asg_act_id
453: and ppa.business_group_id = pbg.business_group_id
454: and paa.payroll_action_id = ppa.payroll_action_id;

Line 513: pay_payroll_actions ppa

509: --
510: select ptp.start_date
511: into l_start_date
512: from per_time_periods ptp,
513: pay_payroll_actions ppa
514: where ppa.payroll_action_id = p_payroll_action_id
515: and ppa.payroll_id = ptp.payroll_id
516: and ppa.date_earned between ptp.start_date
517: and ptp.end_date;

Line 670: from pay_payroll_actions ppa,

666: into l_date_earned,
667: l_prd_end_date,
668: l_prd_start_date,
669: l_prorate_grp_id
670: from pay_payroll_actions ppa,
671: pay_assignment_actions paa,
672: per_time_periods ptp,
673: pay_element_types_f pet
674: where paa.assignment_action_id = p_asg_act_id

Line 962: pay_payroll_actions ppa

958: select INTLK.locking_action_id
959: into l_action_id
960: from pay_action_interlocks INTLK,
961: pay_assignment_actions paa,
962: pay_payroll_actions ppa
963: where INTLK.locked_action_id = p_action_id
964: and INTLK.locking_action_id = paa.assignment_action_id
965: and paa.payroll_action_id = ppa.payroll_action_id
966: and ppa.action_type in ('P', 'U')

Line 1067: pay_payroll_actions ppa

1063: into l_run_method
1064: from pay_run_types_f prt_aa,
1065: pay_run_types_f prt_pa,
1066: pay_assignment_actions paa,
1067: pay_payroll_actions ppa
1068: where paa.assignment_action_id = p_calling_action_id
1069: and paa.payroll_action_id = ppa.payroll_action_id
1070: and paa.run_type_id = prt_aa.run_type_id (+)
1071: and ppa.effective_date between nvl(prt_aa.effective_start_date, ppa.effective_date)

Line 1188: pay_payroll_actions ppa

1184: select parameter_value
1185: into p_para_value
1186: from pay_report_format_parameters prfp,
1187: pay_report_format_mappings_f prfm,
1188: pay_payroll_actions ppa
1189: where ppa.payroll_action_id = p_payroll_action_id
1190: and ppa.report_type = prfm.report_type
1191: and ppa.report_qualifier = prfm.report_qualifier
1192: and ppa.report_category = prfm.report_category

Line 1807: l_eff_date pay_payroll_actions.effective_date%type;

1803: 'S', 1,
1804: 2);
1805: --
1806: l_run_meth pay_run_types_f.run_method%type;
1807: l_eff_date pay_payroll_actions.effective_date%type;
1808: l_ee_id pay_run_results.source_id%type;
1809: --
1810: begin
1811: --

Line 1818: pay_payroll_actions ppa

1814: into l_run_meth,
1815: l_eff_date
1816: from pay_run_types_f prt,
1817: pay_assignment_actions paa,
1818: pay_payroll_actions ppa
1819: where paa.assignment_action_id = p_asg_action_id
1820: and ppa.payroll_action_id = paa.payroll_action_id
1821: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)
1822: and ppa.effective_date

Line 2256: from pay_payroll_actions ppa,

2252: begin
2253:
2254: select ppf.payroll_name
2255: into l_payroll_name
2256: from pay_payroll_actions ppa,
2257: pay_payrolls_f ppf
2258: where ppa.payroll_action_id=p_pactid
2259: and nvl(ppa.payroll_id,-9999)=ppf.payroll_id
2260: and ppa.effective_date between ppf.effective_start_date and effective_end_date;

Line 2289: pay_payroll_actions ppa,

2285: if (g_leg_code is null) then
2286: select pbg.legislation_code
2287: into g_leg_code
2288: from pay_assignment_actions paa,
2289: pay_payroll_actions ppa,
2290: per_business_groups_perf pbg
2291: where paa.assignment_action_id = p_asg_act_id
2292: and ppa.business_group_id = pbg.business_group_id
2293: and paa.payroll_action_id = ppa.payroll_action_id;