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 132: from pay_payroll_actions ppa

128: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)
129: into ln_year,
130: ln_gre_id,
131: ln_assign_set
132: from pay_payroll_actions ppa
133: where ppa.payroll_action_id = pactid;
134:
135: -- hr_us_w2_rep.initialize_assignment_set(ln_assign_set);
136:

Line 140: PAY_PAYROLL_ACTIONS ppa_arch

136:
137: sqlstr :=
138: 'SELECT distinct to_number(paa_arch.serial_number)
139: FROM PAY_ASSIGNMENT_ACTIONS paa_arch,
140: PAY_PAYROLL_ACTIONS ppa_arch
141: WHERE :pactid is not null
142: AND ppa_arch.report_type = ''YREND''
143: AND to_char(ppa_arch.effective_date,''YYYY'')= '''||ln_year||'''
144: AND pay_yrend_reports_pkg.get_parameter(''TRANSFER_GRE'',

Line 175: l_report_type pay_payroll_actions.report_type%type;

171:
172: num number;
173: l_effective_end_date DATE;
174: l_effective_date DATE;
175: l_report_type pay_payroll_actions.report_type%type;
176: l_report_category pay_payroll_actions.report_category%type;
177: l_report_qualifier pay_payroll_actions.report_qualifier%type;
178: l_report_format pay_report_format_mappings_f.report_format%type;
179: l_range_person_on BOOLEAN;

Line 176: l_report_category pay_payroll_actions.report_category%type;

172: num number;
173: l_effective_end_date DATE;
174: l_effective_date DATE;
175: l_report_type pay_payroll_actions.report_type%type;
176: l_report_category pay_payroll_actions.report_category%type;
177: l_report_qualifier pay_payroll_actions.report_qualifier%type;
178: l_report_format pay_report_format_mappings_f.report_format%type;
179: l_range_person_on BOOLEAN;
180: l_subj_whable ff_user_entities.user_entity_name%TYPE;

Line 177: l_report_qualifier pay_payroll_actions.report_qualifier%type;

173: l_effective_end_date DATE;
174: l_effective_date DATE;
175: l_report_type pay_payroll_actions.report_type%type;
176: l_report_category pay_payroll_actions.report_category%type;
177: l_report_qualifier pay_payroll_actions.report_qualifier%type;
178: l_report_format pay_report_format_mappings_f.report_format%type;
179: l_range_person_on BOOLEAN;
180: l_subj_whable ff_user_entities.user_entity_name%TYPE;
181: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;

Line 195: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;

191: l_per_id per_assignments_f.person_id%type;
192: l_ssn per_people_f.national_identifier%type;
193: l_state_code pay_us_states.state_code%type;
194: l_asg_set_id number;
195: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
196: l_eoy_start_date date;
197: ln_gross_bal number;
198:
199:

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

212: ppa1.effective_date,
213: ppa1.report_type,
214: ppa1.report_qualifier,
215: ppa1.report_category
216: from pay_payroll_actions ppa, /* EOY payroll action id */
217: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
218: where ppa1.payroll_action_id = cp_pactid
219: and ppa.effective_date = ppa1.effective_date
220: and ppa.report_type = 'YREND'

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

213: ppa1.report_type,
214: ppa1.report_qualifier,
215: ppa1.report_category
216: from pay_payroll_actions ppa, /* EOY payroll action id */
217: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
218: where ppa1.payroll_action_id = cp_pactid
219: and ppa.effective_date = ppa1.effective_date
220: and ppa.report_type = 'YREND'
221: and pay_1099R_pkg.get_parameter

Line 240: from pay_payroll_actions ppa

236: effective_date,
237: report_type,
238: report_qualifier,
239: report_category
240: from pay_payroll_actions ppa
241: where ppa.payroll_action_id = cp_pactid;
242: */
243:
244: /* when person or ssn selected */

Line 1015: from pay_payroll_actions ppa

1011: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
1012: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
1013: ppa.legislative_parameters)),'DD-MON-YYYY')
1014: into l_effective_date, l_session_date
1015: from pay_payroll_actions ppa
1016: where payroll_action_id = payactid;
1017:
1018: if to_date(l_session_date,'DD-MM-YYYY') > to_date(l_effective_date,'DD-MM-YYYY') then
1019: l_effective_date := l_session_date;

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

1024: /* we need the row id of the assignment actions
1025: that are created by PYUGEN */
1026: from pay_assignment_actions paa,
1027: pay_assignment_actions paa1, /* PYUGEN assignment action */
1028: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
1029: where ppa1.payroll_action_id = :pactid
1030: and paa1.payroll_action_id = ppa1.payroll_action_id
1031: and paa.assignment_action_id = paa1.serial_number
1032: order by

Line 1097: token_val pay_payroll_actions.legislative_parameters%type;

1093: parameter_list varchar2) return varchar2
1094: is
1095: start_ptr number;
1096: end_ptr number;
1097: token_val pay_payroll_actions.legislative_parameters%type;
1098: par_value pay_payroll_actions.legislative_parameters%type;
1099: begin
1100: --
1101: token_val := name||'=';

Line 1098: par_value pay_payroll_actions.legislative_parameters%type;

1094: is
1095: start_ptr number;
1096: end_ptr number;
1097: token_val pay_payroll_actions.legislative_parameters%type;
1098: par_value pay_payroll_actions.legislative_parameters%type;
1099: begin
1100: --
1101: token_val := name||'=';
1102: --

Line 1413: PAY_PAYROLL_ACTIONS PPA, --PYUGEN

1409: v1099r.irr_amount irr_amount, -- Bug 11906843
1410: paa.tax_unit_id -- Added for #8239671
1411: from
1412: PAY_ASSIGNMENT_ACTIONS PAA, --PYUGEN
1413: PAY_PAYROLL_ACTIONS PPA, --PYUGEN
1414: PAY_US_WAGES_1099r_v v1099r
1415: WHERE
1416: paa.assignment_action_id = p_asg_actid
1417: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1425: FROM pay_payroll_actions ppa,

1421: CURSOR c_parameters (asg_actid in NUMBER) IS
1422: SELECT ppa.legislative_parameters,
1423: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1424: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1425: FROM pay_payroll_actions ppa,
1426: pay_assignment_actions paa
1427: WHERE paa.assignment_action_id = asg_actid
1428: and ppa.payroll_action_id = paa.payroll_action_id;
1429:

Line 1459: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;

1455: l_addr_line1 per_addresses.address_line1%TYPE;
1456: l_addr_line2 per_addresses.address_line2%TYPE;
1457: l_city_state_zip varchar2(100);
1458: l_eff_date date;
1459: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1460: l_st_tax_unit_id number;
1461: l_st_assign_id number;
1462: l_state_ein varchar2(50);
1463: l_sit_subject number;