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_CA_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 100: pay_assignment_actions paa

96:
97: cursor csr_get_jd is
98: Select employment_province, geocode
99: from pay_ca_emp_all_fedtax_info_v cft,
100: pay_assignment_actions paa
101: where cft.assignment_id = paa.assignment_id
102: and paa.assignment_action_id = p_asg_act_id;
103:
104: BEGIN

Line 127: ,pay_assignment_actions paa

123: ,segment11 T4A_RL1_GRE
124: ,segment12 T4A_RL2_GRE
125: from hr_soft_coding_keyflex hsck
126: ,per_all_assignments_f paf
127: ,pay_assignment_actions paa
128: ,pay_payroll_actions ppa
129: where paa.assignment_action_id = cp_asg_act_id
130: and ppa.payroll_action_id = paa.payroll_action_id
131: and paf.assignment_id = paa.assignment_id

Line 149: ,pay_assignment_actions paa

145: decode(segment12, NULL, 0, 1 ) tot_no_of_tu
146: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
147: from hr_soft_coding_keyflex hsck
148: ,per_all_assignments_f paf
149: ,pay_assignment_actions paa
150: ,pay_payroll_actions ppa
151: where paa.assignment_action_id = cp_asg_act_id
152: and ppa.payroll_action_id = paa.payroll_action_id
153: and paf.assignment_id = paa.assignment_id

Line 279: FROM per_assignments_f paf, pay_assignment_actions paa

275: PROCEDURE add_custom_xml as
276:
277: /* CURSOR get_assignment_number(p_asg_action_id number) IS
278: SELECT assignment_number
279: FROM per_assignments_f paf, pay_assignment_actions paa
280: WHERE paa.assignment_action_id = p_asg_action_id
281: and paa.assignment_id = paf.assignment_id; */
282:
283: TYPE char_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 388: FROM pay_assignment_actions

384: select DISTINCT ft.nls_territory
385: from pay_action_information pai,fnd_territories ft
386: where pai.action_context_id =
387: (SELECT payroll_action_id
388: FROM pay_assignment_actions
389: WHERE assignment_action_id = cp_assignment_action_id)
390: and pai.action_information_category='ADDRESS DETAILS'
391: and ft.territory_code=pai.action_information13;
392:

Line 433: pay_assignment_actions paa

429: pai.action_information10, paa.serial_number
430: FROM pay_action_information pai,
431: pay_org_payment_methods_f popmf,
432: pay_payment_types ppt,
433: pay_assignment_actions paa
434: WHERE pai.action_context_id = arch_assact_id
435: AND pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
436: AND paa.assignment_action_id = chk_assact_id
437: AND popmf.org_payment_method_id = pai.action_information1

Line 449: FROM pay_assignment_actions

445: WHERE locking_action_id = arch_assact_id; */
446: /* Bug 14052902 - Modified the cursor to display appropriate advice number
447: in Emloyee details section when seperate payemnts are made */
448: SELECT fnd_number.canonical_to_number (substr (serial_number,3))
449: FROM pay_assignment_actions
450: WHERE assignment_action_id = arch_assact_id;
451:
452: /*Changes for bug 13870178 starts here */
453: /* Bug 14052902 - Modified following cursor to display Bonus amount in Net Pay Distribution Section */

Line 467: , pay_assignment_actions_pkg.get_payment_status (pail.locked_action_id, pai.action_information15) status

463: , pai.action_information16
464: , pai.action_information2
465: , pai.action_information11
466: , ppt.category
467: , pay_assignment_actions_pkg.get_payment_status (pail.locked_action_id, pai.action_information15) status
468: FROM pay_action_information pai
469: , pay_org_payment_methods_f popmf
470: , pay_payment_types ppt
471: , pay_action_interlocks pail

Line 473: , pay_assignment_actions paa

469: , pay_org_payment_methods_f popmf
470: , pay_payment_types ppt
471: , pay_action_interlocks pail
472: , pay_payroll_actions ppa
473: , pay_assignment_actions paa
474: , pay_assignment_actions paa2
475: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
476: AND pai.action_context_id = arch_assact_id
477: AND paa2.assignment_action_id = pai.action_context_id

Line 474: , pay_assignment_actions paa2

470: , pay_payment_types ppt
471: , pay_action_interlocks pail
472: , pay_payroll_actions ppa
473: , pay_assignment_actions paa
474: , pay_assignment_actions paa2
475: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
476: AND pai.action_context_id = arch_assact_id
477: AND paa2.assignment_action_id = pai.action_context_id
478: AND pai.action_context_id = pail.locking_action_id

Line 499: pay_assignment_actions paa,

495: 'Savings Account'
496: ),
497: pain.action_information7
498: FROM pay_action_interlocks pai,
499: pay_assignment_actions paa,
500: pay_payroll_actions ppa,
501: pay_action_interlocks pai1,
502: pay_action_information pain
503: WHERE pai.locking_action_id = cp_assignment_action_id

Line 519: FROM pay_assignment_actions paa

515: , pai.action_information3 amount
516: , ltrim (initcap (rtrim (ppf.title)) || ' ' || rtrim (ppf.first_name) || ' ' || rtrim (ppf.last_name)) employee_name
517: , pea.segment4 er_transit_code /*13849708*/
518: , pea.segment3 er_account_number /*13849708*/
519: FROM pay_assignment_actions paa
520: , pay_action_information pai
521: , per_all_assignments_f paf
522: , per_all_people_f ppf
523: , pay_external_accounts pea