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

Line 116: from pay_payroll_actions ppa

112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
113: into ln_year,
114: ln_gre_id,
115: ln_assign_set
116: from pay_payroll_actions ppa
117: where ppa.payroll_action_id = pactid;
118:
119: -- hr_us_w2_rep.initialize_assignment_set(ln_assign_set);
120:

Line 124: PAY_PAYROLL_ACTIONS ppa_arch

120:
121: sqlstr :=
122: 'SELECT distinct to_number(paa_arch.serial_number)
123: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,
124: PAY_PAYROLL_ACTIONS ppa_arch
125: WHERE :pactid is not null
126: AND ppa_arch.report_type = ''YREND''
127: AND to_char(ppa_arch.effective_date,''YYYY'')= '''||ln_year||'''
128: AND pay_yrend_reports_pkg.get_parameter(''TRANSFER_GRE'',

Line 159: l_report_type pay_payroll_actions.report_type%type;

155:
156: num number;
157: l_effective_end_date DATE;
158: l_effective_date DATE;
159: l_report_type pay_payroll_actions.report_type%type;
160: l_report_category pay_payroll_actions.report_category%type;
161: l_report_qualifier pay_payroll_actions.report_qualifier%type;
162: l_report_format pay_report_format_mappings_f.report_format%type;
163: l_range_person_on BOOLEAN;

Line 160: l_report_category pay_payroll_actions.report_category%type;

156: num number;
157: l_effective_end_date DATE;
158: l_effective_date DATE;
159: l_report_type pay_payroll_actions.report_type%type;
160: l_report_category pay_payroll_actions.report_category%type;
161: l_report_qualifier pay_payroll_actions.report_qualifier%type;
162: l_report_format pay_report_format_mappings_f.report_format%type;
163: l_range_person_on BOOLEAN;
164: l_subj_whable ff_user_entities.user_entity_name%TYPE;

Line 161: l_report_qualifier pay_payroll_actions.report_qualifier%type;

157: l_effective_end_date DATE;
158: l_effective_date DATE;
159: l_report_type pay_payroll_actions.report_type%type;
160: l_report_category pay_payroll_actions.report_category%type;
161: l_report_qualifier pay_payroll_actions.report_qualifier%type;
162: l_report_format pay_report_format_mappings_f.report_format%type;
163: l_range_person_on BOOLEAN;
164: l_subj_whable ff_user_entities.user_entity_name%TYPE;
165: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;

Line 179: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

175: l_per_id per_assignments_f.person_id%type;
176: l_ssn per_people_f.national_identifier%type;
177: l_state_code pay_us_states.state_code%type;
178: l_asg_set_id number;
179: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
180: l_eoy_start_date date;
181: ln_gross_bal number;
182:
183:

Line 200: from pay_payroll_actions ppa, /* EOY payroll action id */

196: ppa1.effective_date,
197: ppa1.report_type,
198: ppa1.report_qualifier,
199: ppa1.report_category
200: from pay_payroll_actions ppa, /* EOY payroll action id */
201: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
202: where ppa1.payroll_action_id = cp_pactid
203: and ppa.effective_date = ppa1.effective_date
204: and ppa.report_type = 'YREND'

Line 201: pay_payroll_actions ppa1 /* PYUGEN payroll action id */

197: ppa1.report_type,
198: ppa1.report_qualifier,
199: ppa1.report_category
200: from pay_payroll_actions ppa, /* EOY payroll action id */
201: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
202: where ppa1.payroll_action_id = cp_pactid
203: and ppa.effective_date = ppa1.effective_date
204: and ppa.report_type = 'YREND'
205: and pay_1099R_pkg.get_parameter

Line 224: from pay_payroll_actions ppa

220: effective_date,
221: report_type,
222: report_qualifier,
223: report_category
224: from pay_payroll_actions ppa
225: where ppa.payroll_action_id = cp_pactid;
226: */
227:
228: /* when person or ssn selected */

Line 999: from pay_payroll_actions ppa

995: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
997: ppa.legislative_parameters)),'DD-MON-YYYY')
998: into l_effective_date, l_session_date
999: from pay_payroll_actions ppa
1000: where payroll_action_id = payactid;
1001:
1002: if to_date(l_session_date,'DD-MM-YYYY') > to_date(l_effective_date,'DD-MM-YYYY') then
1003: l_effective_date := l_session_date;

Line 1012: pay_payroll_actions ppa1 /* PYUGEN payroll action id */

1008: /* we need the row id of the assignment actions
1009: that are created by PYUGEN */
1010: from pay_assignment_actions paa,
1011: pay_assignment_actions paa1, /* PYUGEN assignment action */
1012: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1013: where ppa1.payroll_action_id = :pactid
1014: and paa1.payroll_action_id = ppa1.payroll_action_id
1015: and paa.assignment_action_id = paa1.serial_number
1016: order by

Line 1081: token_val pay_payroll_actions.legislative_parameters%type;

1077: parameter_list varchar2) return varchar2
1078: is
1079: start_ptr number;
1080: end_ptr number;
1081: token_val pay_payroll_actions.legislative_parameters%type;
1082: par_value pay_payroll_actions.legislative_parameters%type;
1083: begin
1084: --
1085: token_val := name||'=';

Line 1082: par_value pay_payroll_actions.legislative_parameters%type;

1078: is
1079: start_ptr number;
1080: end_ptr number;
1081: token_val pay_payroll_actions.legislative_parameters%type;
1082: par_value pay_payroll_actions.legislative_parameters%type;
1083: begin
1084: --
1085: token_val := name||'=';
1086: --

Line 1395: PAY_PAYROLL_ACTIONS PPA, --PYUGEN

1391: nvl(hr_us_w2_rep.get_per_item(v1099r.assignment_action_id, 'A_DISTRIBUTION_CODE_FOR_1099R'),'7') ee_distribution_code,
1392: v1099r.defferal_year defferal_year
1393: from
1394: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN
1395: PAY_PAYROLL_ACTIONS PPA, --PYUGEN
1396: PAY_US_WAGES_1099r_v v1099r
1397: WHERE
1398: paa.assignment_action_id = p_asg_actid
1399: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1407: FROM pay_payroll_actions ppa,

1403: CURSOR c_parameters (asg_actid in NUMBER) IS
1404: SELECT ppa.legislative_parameters,
1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1407: FROM pay_payroll_actions ppa,
1408: pay_assignment_actions paa
1409: WHERE paa.assignment_action_id = asg_actid
1410: and ppa.payroll_action_id = paa.payroll_action_id;
1411:

Line 1441: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;

1437: l_addr_line1 per_addresses.address_line1%TYPE;
1438: l_addr_line2 per_addresses.address_line2%TYPE;
1439: l_city_state_zip varchar2(100);
1440: l_eff_date date;
1441: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1442: l_st_tax_unit_id number;
1443: l_st_assign_id number;
1444: l_state_ein varchar2(50);
1445: l_sit_subject number;