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_PAYROLL_ACTIONS

Line 455: from pay_payroll_actions ppa2,

451: and paa.run_type_id = l_run_type_id
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

Line 470: from pay_payroll_actions ppa,

466: --
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

Line 484: from pay_payroll_actions ppa2,

480: and ppa.report_category = decode(substr(lpad(p_type,4),1,1),'I','I','R','R','N')
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

Line 547: pay_payroll_actions ppa,

543: nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbf.scale),0) value
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

Line 671: from pay_payroll_actions xppa,

667: is
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

Line 674: pay_payroll_actions ppa,

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
677: and ppa.payroll_action_id = paa.payroll_action_id
678: and pai.locked_action_id (+) = paa.assignment_action_id

Line 758: from pay_payroll_actions ppa,

754: cursor csr_assact
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: --

Line 823: l_payroll_id pay_payroll_actions.payroll_id%type;

819: l_archive varchar2(1);
820: l_cache varchar2(1);
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;

Line 824: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

820: l_cache varchar2(1);
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: --

Line 826: l_date_earned pay_payroll_actions.date_earned%type;

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
830: --

Line 836: from pay_payroll_actions xppa,

832: is
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

Line 839: pay_payroll_actions ppa,

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
842: and ppa.payroll_action_id = paa.payroll_action_id
843: and pai.locked_action_id (+) = paa.assignment_action_id

Line 861: pay_payroll_actions ppa,

857: ppa.date_earned date_earned,
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;

Line 959: from pay_payroll_actions ppa,

955: cursor csr_assact
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: --

Line 1030: pay_payroll_actions ppa,

1026: select pet.element_type_id,
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

Line 1085: pay_payroll_actions ppa,

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

Line 1132: pay_payroll_actions ppa,

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

Line 1259: pay_payroll_actions ppa,

1255: select
1256: fnd_number.canonical_to_number(prrv.result_value) value
1257: from pay_run_result_values prrv,
1258: pay_run_results prr,
1259: pay_payroll_actions ppa,
1260: pay_assignment_actions paa
1261: where paa.assignment_action_id = p_assignment_action_id
1262: and ppa.payroll_action_id = paa.payroll_action_id
1263: and prr.assignment_action_id = paa.assignment_action_id

Line 1306: pay_payroll_actions ppa,

1302: select pet.element_type_id,
1303: piv.input_value_id
1304: from pay_input_values_f piv,
1305: pay_element_types_f pet,
1306: pay_payroll_actions ppa,
1307: pay_assignment_actions paa
1308: where paa.assignment_action_id = p_assignment_action_id
1309: and ppa.payroll_action_id = paa.payroll_action_id
1310: and pet.element_name = p_element_type_name

Line 1360: pay_payroll_actions ppa,

1356: select
1357: prrv.result_value value
1358: from pay_run_result_values prrv,
1359: pay_run_results prr,
1360: pay_payroll_actions ppa,
1361: pay_assignment_actions paa
1362: where paa.assignment_action_id = p_assignment_action_id
1363: and ppa.payroll_action_id = paa.payroll_action_id
1364: and prr.assignment_action_id = paa.assignment_action_id