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

Line 101: in pay_payroll_actions table. Procedure

97: while calling the procedure
98: pay_ac_action_arch.get_last_xfr_info
99: 28-Jan-2010 npannamp 115.123 8768738 Removed fix done in 8688998.
100: 28-Dec-2009 npannamp 115.122 8768738 Added code to update payroll_id column
101: in pay_payroll_actions table. Procedure
102: action_archinit modified.
103: 19-Oct-2009 kagangul 115.121 8688998 Adding two more parameters
104: 1. p_archive_balance_info
105: 2. p_legislation_code

Line 491: from pay_payroll_actions

487: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
488: - (instr(legislative_parameters,
489: 'TRANSFER_PAYROLL_ID=')
490: + length('TRANSFER_PAYROLL_ID='))))))
491: from pay_payroll_actions
492: where payroll_action_id = cp_payroll_action_id;
493:
494: ld_end_date DATE;
495: ld_start_date DATE;

Line 638: pay_payroll_actions ppa,

634:
635: lv_sql_string :=
636: 'select distinct paf.person_id
637: from pay_assignment_actions paa,
638: pay_payroll_actions ppa,
639: per_assignments_f paf
640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 662: pay_payroll_actions ppa1

658: (select /*+ ORDERED */
659: 1
660: from pay_action_interlocks pai,
661: pay_assignment_actions paa1,
662: pay_payroll_actions ppa1
663: where pai.locked_action_id = paa.assignment_action_id
664: and paa1.assignment_action_id = pai.locking_action_id
665: and ppa1.payroll_action_id = paa1.payroll_action_id
666: and ppa1.action_type =''X''

Line 702: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)

698: ,cp_start_date in date
699: ,cp_end_date in date
700: ) is
701: select /*+ INDEX(PAF PER_ASSIGNMENTS_F_N12)
702: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
703: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
704: paa.assignment_id,
705: paa.tax_unit_id,
706: ppa.effective_date,

Line 711: from pay_payroll_actions ppa,

707: ppa.date_earned,
708: ppa.action_type,
709: paa.assignment_action_id,
710: paa.payroll_action_id
711: from pay_payroll_actions ppa,
712: pay_assignment_actions paa,
713: per_assignments_f paf
714: where paf.person_id between cp_start_person_id
715: and cp_end_person_id

Line 735: pay_payroll_actions ppa1

731: and not exists
732: (select 'x'
733: from pay_action_interlocks pai1,
734: pay_assignment_actions paa1,
735: pay_payroll_actions ppa1
736: where pai1.locked_action_id = paa.assignment_action_id
737: and paa1.assignment_action_id = pai1.locking_action_id
738: and ppa1.payroll_action_id = paa1.payroll_action_id
739: and ppa1.action_type ='X'

Line 754: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)

750: ,cp_end_date in date
751: ) is
752: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
753: INDEX(PAF PER_ASSIGNMENTS_F_N12)
754: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
755: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
756: paa.assignment_id,
757: paa.tax_unit_id,
758: ppa.effective_date,

Line 763: from pay_payroll_actions ppa,

759: ppa.date_earned,
760: ppa.action_type,
761: paa.assignment_action_id,
762: paa.payroll_action_id
763: from pay_payroll_actions ppa,
764: pay_assignment_actions paa,
765: per_assignments_f paf,
766: pay_population_ranges ppr
767: where ppr.payroll_action_id = cp_payroll_action_id

Line 789: pay_payroll_actions ppa1

785: and not exists
786: (select 'x'
787: from pay_action_interlocks pai1,
788: pay_assignment_actions paa1,
789: pay_payroll_actions ppa1
790: where pai1.locked_action_id = paa.assignment_action_id
791: and paa1.assignment_action_id = pai1.locking_action_id
792: and ppa1.payroll_action_id = paa1.payroll_action_id
793: and ppa1.action_type ='X'

Line 799: from pay_payroll_actions ppa,

795: order by 1,2,3,5,6;
796:
797: cursor c_master_action(cp_prepayment_action_id number) is
798: select max(paa.assignment_action_id)
799: from pay_payroll_actions ppa,
800: pay_assignment_actions paa,
801: pay_action_interlocks pai
802: where pai.locking_action_Id = cp_prepayment_action_id
803: and paa.assignment_action_id = pai.locked_action_id

Line 1059: from pay_payroll_actions ppa

1055: ln_step NUMBER;
1056:
1057: cursor c_asg_actions (cp_payroll_action_id in number) is
1058: select ppa.effective_date
1059: from pay_payroll_actions ppa
1060: where ppa.payroll_action_id = cp_payroll_action_id;
1061:
1062: cursor c_get_balance_type_id (cp_balance_name in varchar2) is
1063: select balance_type_id

Line 1135: leg_param pay_payroll_actions.legislative_parameters%TYPE;

1131: where parameter_name = 'INIT_PAY_ARCHIVE';
1132:
1133: /* Bug 8768738 Fix */
1134: l_payroll_id NUMBER;
1135: leg_param pay_payroll_actions.legislative_parameters%TYPE;
1136: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
1137: l_key varchar2(30) := 'TRANSFER_PAYROLL_ID=';
1138: l_val pay_payroll_actions.legislative_parameters%TYPE;
1139: /* Bug 8768738 Fix */

Line 1136: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

1132:
1133: /* Bug 8768738 Fix */
1134: l_payroll_id NUMBER;
1135: leg_param pay_payroll_actions.legislative_parameters%TYPE;
1136: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
1137: l_key varchar2(30) := 'TRANSFER_PAYROLL_ID=';
1138: l_val pay_payroll_actions.legislative_parameters%TYPE;
1139: /* Bug 8768738 Fix */
1140: BEGIN

Line 1138: l_val pay_payroll_actions.legislative_parameters%TYPE;

1134: l_payroll_id NUMBER;
1135: leg_param pay_payroll_actions.legislative_parameters%TYPE;
1136: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
1137: l_key varchar2(30) := 'TRANSFER_PAYROLL_ID=';
1138: l_val pay_payroll_actions.legislative_parameters%TYPE;
1139: /* Bug 8768738 Fix */
1140: BEGIN
1141: ln_step := 1;
1142: hr_utility.set_location(gv_package || lv_procedure_name, 1);

Line 1157: FROM pay_payroll_actions

1153:
1154: /* Bug Fix 8768738 */
1155: SELECT legislative_parameters,payroll_id
1156: INTO leg_param,l_ppa_payroll_id
1157: FROM pay_payroll_actions
1158: WHERE payroll_action_id = p_payroll_action_id ;
1159:
1160: if instr(leg_param, l_key) <> 0 then
1161: l_val := substr(leg_param, instr(leg_param, l_key));

Line 1173: UPDATE pay_payroll_actions

1169: -- Update the Payroll Action with the Payroll ID
1170:
1171: IF l_ppa_payroll_id IS NULL THEN
1172:
1173: UPDATE pay_payroll_actions
1174: SET payroll_id = l_payroll_id
1175: WHERE payroll_action_id = p_payroll_action_id;
1176:
1177: END IF;

Line 1819: from pay_payroll_actions

1815: IS
1816:
1817: cursor c_effective_date (cp_payroll_action_id in number) is
1818: select effective_date
1819: from pay_payroll_actions
1820: where payroll_action_id = cp_payroll_action_id;
1821:
1822: l_effective_date DATE;
1823: lv_error_message VARCHAR2(200);

Line 1887: pay_payroll_actions ppa

1883: cursor c_pymt_eff_date(cp_run_action_id in number) is
1884: select ppa.effective_date
1885: from pay_assignment_actions paa,
1886: pay_assignment_actions paa1,
1887: pay_payroll_actions ppa
1888: where paa.assignment_action_id = cp_run_action_id
1889: and paa1.assignment_action_id=to_number(substr(paa.serial_number,3))
1890: and paa1.payroll_action_id=ppa.payroll_action_id;
1891: /*Bug# 16318258 - End */

Line 6257: pay_payroll_actions ppa,

6253: pay_input_values_f piv_att,
6254: pay_element_entries_f peef,
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6257: pay_payroll_actions ppa,
6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,

Line 6341: pay_payroll_actions ppa,

6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6341: pay_payroll_actions ppa,
6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,
6345: pay_input_values_f piv_pay,

Line 6448: pay_payroll_actions ppa,

6444: from pay_element_entry_values_f peev,
6445: pay_input_values_f piv_att,
6446: pay_element_entries_f peef,
6447: pay_run_results prr_att,
6448: pay_payroll_actions ppa,
6449: pay_assignment_actions paa,
6450: pay_action_interlocks pai,
6451: pay_pre_payments ppp,
6452: pay_run_result_values prrv_att,

Line 6821: pay_payroll_actions ppa_run

6817: and exists (
6818: select ''
6819: from pay_run_types_f prt,
6820: pay_assignment_actions paa_run,
6821: pay_payroll_actions ppa_run
6822: where paa_run.assignment_action_id
6823: = ppp.source_action_id
6824: and paa_run.payroll_action_id
6825: = ppa_run.payroll_action_id

Line 7192: pay_payroll_actions ppa

7188: ,cp_sepchk_run_type in number) is
7189: select paa.assignment_action_id
7190: from pay_assignment_actions paa,
7191: pay_action_interlocks pai,
7192: pay_payroll_actions ppa
7193: where pai.locking_action_id = cp_prepayment_action_id
7194: and paa.assignment_action_id = pai.locked_action_id
7195: and paa.assignment_id = cp_assignment_id
7196: and ppa.payroll_action_id = paa.payroll_action_id

Line 7208: pay_payroll_actions ppa,

7204: nvl(ppa.date_earned,ppa.effective_date),
7205: --bug 7379102
7206: ppa.effective_date
7207: from pay_assignment_actions paa,
7208: pay_payroll_actions ppa,
7209: per_time_periods ptp
7210: where paa.assignment_action_id = cp_run_assignment_action
7211: and ppa.payroll_action_id = paa.payroll_action_id
7212: and ptp.payroll_id = ppa.payroll_id

Line 7665: pay_payroll_actions ppa

7661: cursor c_assignment_run (cp_prepayment_action_id in number) is
7662: select distinct paa.assignment_id
7663: from pay_action_interlocks pai,
7664: pay_assignment_actions paa,
7665: pay_payroll_actions ppa
7666: where pai.locking_action_id = cp_prepayment_action_id
7667: and paa.assignment_action_id = pai.locked_action_id
7668: and ppa.payroll_action_id = paa.payroll_action_id
7669: and ppa.action_type in ('R', 'Q', 'B')

Line 7679: from pay_payroll_actions ppa,

7675: cp_prepayment_action_id in number,
7676: cp_assignment_id in number) is
7677: select paa.assignment_action_id, paa.payroll_action_id,
7678: ppa.action_type
7679: from pay_payroll_actions ppa,
7680: pay_assignment_actions paa,
7681: pay_action_interlocks pai
7682: where pai.locking_action_id = cp_prepayment_action_id
7683: and pai.locked_action_id = paa.assignment_action_id

Line 7691: from pay_payroll_actions ppa,

7687: order by paa.assignment_action_id desc;
7688:
7689: cursor c_pymt_eff_date(cp_prepayment_action_id in number) is
7690: select ppa.effective_date
7691: from pay_payroll_actions ppa,
7692: pay_assignment_actions paa
7693: where ppa.payroll_action_id = paa.payroll_action_id
7694: and paa.assignment_action_id = cp_prepayment_action_id;
7695:

Line 7754: ,pay_payroll_actions ppa

7750: paf1.assignment_id,
7751: paa.assignment_action_id
7752: from per_all_assignments_f paf1
7753: ,pay_assignment_actions paa
7754: ,pay_payroll_actions ppa
7755: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
7756: from per_all_assignments_f START_ASS
7757: where START_ASS.assignment_id = cp_assignment_id
7758: and rownum = 1)