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

Line 449: from pay_assignment_actions paa

445: -- (From performance repository SQLID: 9609734)
446: cursor csr_latest_assact_run_type
447: is
448: select assignment_action_id
449: from pay_assignment_actions paa
450: where paa.assignment_id = p_assignment_id
451: and paa.run_type_id = l_run_type_id
452: and paa.action_sequence =
453: (

Line 456: pay_assignment_actions paa2

452: and paa.action_sequence =
453: (
454: select max(paa2.action_sequence)
455: from pay_payroll_actions ppa2,
456: pay_assignment_actions paa2
457: where paa2.assignment_id = p_assignment_id
458: and paa2.run_type_id = l_run_type_id
459: and paa2.action_status in ('C', 'S') -- Bug 4442484: Include 'S'kipped assacts
460: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 471: pay_assignment_actions paa

467: cursor csr_latest_assact_report_type
468: is
469: select paa.assignment_action_id
470: from pay_payroll_actions ppa,
471: pay_assignment_actions paa
472: where paa.assignment_id = p_assignment_id
473: and paa.run_type_id is null
474: and paa.action_status in ('C', 'S') -- Bug 4442484: Include 'S'kipped assacts
475: and ppa.payroll_action_id = paa.payroll_action_id

Line 485: pay_assignment_actions paa2

481: and ppa.report_qualifier = 'KR'
482: and not exists(
483: select null
484: from pay_payroll_actions ppa2,
485: pay_assignment_actions paa2
486: where paa2.assignment_id = paa.assignment_id
487: and paa2.run_type_id is null
488: and paa2.action_status in ('C', 'S') -- Bug 4442484: Include 'S'kipped assacts
489: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 548: pay_assignment_actions paa

544: from pay_balance_feeds_f pbf,
545: pay_run_result_values prrv,
546: pay_run_results prr,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa
549: where paa.assignment_action_id = p_assignment_action_id
550: and ppa.payroll_action_id = paa.payroll_action_id
551: and prr.assignment_action_id = paa.assignment_action_id
552: and prr.status in ('P','PA')

Line 672: pay_assignment_actions xpaa,

668: select ppa.business_group_id,
669: paa.assignment_action_id,
670: nvl(xpaa.assignment_action_id,-1)
671: from pay_payroll_actions xppa,
672: pay_assignment_actions xpaa,
673: pay_action_interlocks pai,
674: pay_payroll_actions ppa,
675: pay_assignment_actions paa
676: where paa.assignment_action_id = p_assignment_action_id

Line 675: pay_assignment_actions paa

671: from pay_payroll_actions xppa,
672: pay_assignment_actions xpaa,
673: pay_action_interlocks pai,
674: pay_payroll_actions ppa,
675: pay_assignment_actions paa
676: where paa.assignment_action_id = p_assignment_action_id
677: and ppa.payroll_action_id = paa.payroll_action_id
678: and pai.locked_action_id (+) = paa.assignment_action_id
679: and xpaa.assignment_action_id (+) = pai.locking_action_id

Line 759: pay_assignment_actions paa

755: is
756: select ppa.business_group_id,
757: paa.assignment_action_id
758: from pay_payroll_actions ppa,
759: pay_assignment_actions paa
760: where paa.assignment_action_id = p_assignment_action_id
761: and ppa.payroll_action_id = paa.payroll_action_id;
762: --
763: begin

Line 825: l_assignment_id pay_assignment_actions.assignment_id%type;

821: --
822: l_user_name ff_database_items.user_name%type;
823: l_payroll_id pay_payroll_actions.payroll_id%type;
824: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
825: l_assignment_id pay_assignment_actions.assignment_id%type;
826: l_date_earned pay_payroll_actions.date_earned%type;
827: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
828: --
829: -- Not support for multi action for same action_id

Line 827: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

823: l_payroll_id pay_payroll_actions.payroll_id%type;
824: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
825: l_assignment_id pay_assignment_actions.assignment_id%type;
826: l_date_earned pay_payroll_actions.date_earned%type;
827: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
828: --
829: -- Not support for multi action for same action_id
830: --
831: cursor csr_xassact

Line 837: pay_assignment_actions xpaa,

833: select ppa.business_group_id,
834: paa.assignment_action_id,
835: nvl(xpaa.assignment_action_id,-1)
836: from pay_payroll_actions xppa,
837: pay_assignment_actions xpaa,
838: pay_action_interlocks pai,
839: pay_payroll_actions ppa,
840: pay_assignment_actions paa
841: where paa.assignment_action_id = p_assignment_action_id

Line 840: pay_assignment_actions paa

836: from pay_payroll_actions xppa,
837: pay_assignment_actions xpaa,
838: pay_action_interlocks pai,
839: pay_payroll_actions ppa,
840: pay_assignment_actions paa
841: where paa.assignment_action_id = p_assignment_action_id
842: and ppa.payroll_action_id = paa.payroll_action_id
843: and pai.locked_action_id (+) = paa.assignment_action_id
844: and xpaa.assignment_action_id (+) = pai.locking_action_id

Line 862: pay_assignment_actions paa

858: paa.tax_unit_id tax_unit_id,
859: fdi.user_name user_name
860: from ff_database_items fdi,
861: pay_payroll_actions ppa,
862: pay_assignment_actions paa
863: where paa.assignment_action_id = g_assignment_action_id
864: and ppa.payroll_action_id = paa.payroll_action_id
865: and fdi.user_entity_id = p_user_entity_id;
866: --

Line 960: pay_assignment_actions paa

956: is
957: select ppa.business_group_id,
958: paa.assignment_action_id
959: from pay_payroll_actions ppa,
960: pay_assignment_actions paa
961: where paa.assignment_action_id = p_assignment_action_id
962: and ppa.payroll_action_id = paa.payroll_action_id;
963: --
964: begin

Line 1031: pay_assignment_actions paa

1027: piv.input_value_id
1028: from pay_input_values_f piv,
1029: pay_element_types_f pet,
1030: pay_payroll_actions ppa,
1031: pay_assignment_actions paa
1032: where paa.assignment_action_id = p_assignment_action_id
1033: and ppa.payroll_action_id = paa.payroll_action_id
1034: and pet.element_name = p_element_type_name
1035: and nvl(pet.business_group_id, g_business_group_id) = g_business_group_id

Line 1085: pay_assignment_actions paa

1081: fnd_date.canonical_to_date(prrv.result_value) value
1082: from pay_run_result_values prrv,
1083: pay_run_results prr,
1084: pay_payroll_actions ppa,
1085: pay_assignment_actions paa
1086: where paa.assignment_action_id = p_assignment_action_id
1087: and ppa.payroll_action_id = paa.payroll_action_id
1088: and prr.assignment_action_id = paa.assignment_action_id
1089: and prr.status in ('P','PA')

Line 1132: pay_assignment_actions paa

1128: piv.input_value_id
1129: from pay_input_values_f piv,
1130: pay_element_types_f pet,
1131: pay_payroll_actions ppa,
1132: pay_assignment_actions paa
1133: where paa.assignment_action_id = p_assignment_action_id
1134: and ppa.payroll_action_id = paa.payroll_action_id
1135: and pet.element_name = p_element_type_name
1136: and nvl(pet.business_group_id, g_business_group_id) = g_business_group_id

Line 1186: pay_assignment_actions paa

1182: fnd_number.canonical_to_number(prrv.result_value) value
1183: from pay_run_result_values prrv,
1184: pay_run_results prr,
1185: pay_payroll_actions ppa,
1186: pay_assignment_actions paa
1187: where paa.assignment_action_id = p_assignment_action_id
1188: and ppa.payroll_action_id = paa.payroll_action_id
1189: and prr.assignment_action_id = paa.assignment_action_id
1190: and prr.status in ('P','PA')

Line 1233: pay_assignment_actions paa

1229: piv.input_value_id
1230: from pay_input_values_f piv,
1231: pay_element_types_f pet,
1232: pay_payroll_actions ppa,
1233: pay_assignment_actions paa
1234: where paa.assignment_action_id = p_assignment_action_id
1235: and ppa.payroll_action_id = paa.payroll_action_id
1236: and pet.element_name = p_element_type_name
1237: and nvl(pet.business_group_id, g_business_group_id) = g_business_group_id

Line 1287: pay_assignment_actions paa

1283: prrv.result_value value
1284: from pay_run_result_values prrv,
1285: pay_run_results prr,
1286: pay_payroll_actions ppa,
1287: pay_assignment_actions paa
1288: where paa.assignment_action_id = p_assignment_action_id
1289: and ppa.payroll_action_id = paa.payroll_action_id
1290: and prr.assignment_action_id = paa.assignment_action_id
1291: and prr.status in ('P','PA')