APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PER_ALL_ASSIGNMENTS_F

Line 168: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

164: AND pbt.legislation_code = 'AU'
165: ORDER BY sort_index;
166:
167: /*Bug 4132149 - Modification begins here */
168: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
169: is
170: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
171: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
172: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

Line 409: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

405: ,p_start_person in per_all_people_f.person_id%type
406: ,p_end_person in per_all_people_f.person_id%type
407: ,p_chunk in number
408: ) is
409: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
410: is
411: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
412: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
413: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id

Line 969: FROM per_all_assignments_f paaf,

965: c_start_date date,
966: c_end_date date)
967: IS
968: SELECT paaf.payroll_id, pay.payroll_name
969: FROM per_all_assignments_f paaf,
970: pay_payrolls_f pay
971: WHERE paaf.assignment_id = c_assignment_id
972: and paaf.effective_end_date = (select max(effective_end_date)
973: From per_assignments_f iipaf

Line 2452: procedure summary_rep_populate_allowance(p_assignment_id in per_all_assignments_f.assignment_id%type

2448: -- This procedure is called for the Summary report
2449: -- This procedure identifies the allowance balances processed for
2450: -- assignment in the financial year and populates PL/SQL table.
2451: --------------------------------------------------------------------+
2452: procedure summary_rep_populate_allowance(p_assignment_id in per_all_assignments_f.assignment_id%type
2453: ,p_allowance_exists out nocopy number)
2454: IS
2455:
2456: /* Bug 7138494 - Changed rom Date Earned to Effective date for better

Line 2466: ,per_all_assignments_f paf

2462: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
2463: IS
2464: SELECT DISTINCT pet.element_information2 balance_type_id
2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf
2467: ,pay_payroll_actions ppa
2468: ,pay_assignment_actions paa
2469: ,pay_run_results prr
2470: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date