[Home] [Help]
459: from pay_assignment_actions paa,
460: pay_payroll_actions ppa,
461: pay_run_results prr,
462: pay_element_types_f pet,
463: pay_element_classifications pec,
464: pay_element_types_f_tl petl
465: where prr.assignment_action_id = paa.assignment_action_id
466: and paa.assignment_id = cp_assignment_id
467: and ppa.payroll_action_id = paa.payroll_action_id
522: rpad(nvl(substr(rtrim(ltrim(jurisdiction_code)),8,4),'0')
523: ,4,'0')))), '00-000-0000') jurisdiction_code,
524: pet.element_information10,
525: pet.element_information12
526: from pay_element_classifications pec
527: ,pay_element_types_f pet
528: ,pay_balance_types pbt
529: ,pay_defined_balances pdb
530: ,pay_run_balances prb
1618: select pec.classification_name,
1619: pet.element_information10 primary_balance_id,
1620: pet.element_information12 hours_balance_id
1621: from pay_element_types_f pet,
1622: pay_element_classifications pec
1623: where pet.element_type_id = cp_element_type_id
1624: and p_curr_pymt_eff_date between pet.effective_start_date
1625: and pet.effective_end_date
1626: and pec.classification_id = pet.classification_id;
2165: from pay_assignment_actions paa,
2166: pay_payroll_actions ppa,
2167: per_time_periods ptp,
2168: pay_element_entries_f peef,
2169: pay_element_classifications ec,
2170: pay_element_types et
2171: where paa.assignment_action_id = cp_run_assignment_action_id
2172: and paa.payroll_action_id = ppa.payroll_action_id
2173: and ptp.payroll_id = ppa.payroll_id
2263: from pay_assignment_actions paa,
2264: pay_payroll_actions ppa,
2265: pay_run_results prr,
2266: pay_element_types_f pet,
2267: pay_element_classifications pec,
2268: pay_element_types_f_tl petl
2269: where paa.assignment_id = cp_assignment_id
2270: and prr.assignment_action_id = paa.assignment_action_id
2271: and cp_sepchk_flag = 'Y'
2314: pay_payroll_actions ppa,
2315: pay_all_payrolls_f ppf,
2316: pay_run_results prr,
2317: pay_element_types_f pet,
2318: pay_element_classifications pec,
2319: pay_element_types_f_tl petl
2320: where paa.assignment_id = cp_assignment_id
2321: and prr.assignment_action_id = paa.assignment_action_id
2322: and cp_sepchk_flag = 'N'
3429: PAY_PAYROLL_ACTIONS PPA,
3430: PAY_PAYROLLS_F PPF,
3431: PAY_RUN_RESULTS PRR,
3432: PAY_ELEMENT_TYPES_F PET ,
3433: PAY_ELEMENT_CLASSIFICATIONS PEC,
3434: PAY_ELEMENT_TYPES_F_TL PETL
3435: /*changing the order for bug 5549032
3436: pay_run_results prr,
3437: pay_element_types_f pet ,
3434: PAY_ELEMENT_TYPES_F_TL PETL
3435: /*changing the order for bug 5549032
3436: pay_run_results prr,
3437: pay_element_types_f pet ,
3438: pay_element_classifications pec,
3439: pay_assignment_actions paa,
3440: pay_payroll_actions ppa,
3441: pay_element_types_f_tl petl,
3442: pay_all_payrolls_f ppf */ -- Bug 3370112
4768: per_time_periods ptp,
4769: pay_payroll_actions ppa,
4770: pay_assignment_actions paa,
4771: pay_element_types_f et,
4772: pay_element_classifications ec
4773: where peef.element_entry_id = cp_element_entry_id
4774: AND peef.creator_type IN ('EE', 'NR', 'PR', 'R', 'RR')
4775: AND et.element_type_id = peef.element_type_id
4776: AND et.classification_id = ec.classification_id
5378: from pay_assignment_actions paa,
5379: pay_payroll_actions ppa,
5380: per_time_periods ptp,
5381: pay_element_entries_f peef,
5382: pay_element_classifications ec,
5383: pay_element_types et
5384: where paa.assignment_action_id = cp_run_assignment_action_id
5385: and paa.payroll_action_id = ppa.payroll_action_id
5386: and ptp.payroll_id = ppa.payroll_id
5978: from pay_assignment_actions paa,
5979: pay_payroll_actions ppa,
5980: per_time_periods ptp,
5981: pay_element_entries_f peef,
5982: pay_element_classifications ec,
5983: pay_element_types et
5984: where paa.assignment_action_id = cp_run_assignment_action_id
5985: and paa.payroll_action_id = ppa.payroll_action_id
5986: and ptp.payroll_id = ppa.payroll_id