DBA Data[Home] [Help]

APPS.PAY_KR_SAMPLE_SEP_PKG dependencies on PAY_RUN_TYPES_F

Line 430: pay_run_types_f prt,

426: -- per_time_periods ptp,
427: per_assignment_status_types past,
428: per_assignments_f pa,
429: pay_payroll_actions ppa,
430: pay_run_types_f prt,
431: pay_assignment_actions paa
432: where paa.assignment_id = p_assignment_id
433: and paa.action_status = 'C'
434: and prt.run_type_id = paa.run_type_id

Line 443: from pay_run_types_f prt2

439: 'ALR','BON_ALR',
440: 'MTH')
441: and not exists(
442: select null
443: from pay_run_types_f prt2
444: where prt2.run_type_id = prt.run_type_id
445: and prt2.effective_start_date = prt.effective_start_date
446: and prt2.effective_end_date = prt.effective_end_date
447: and prt2.run_type_name = decode(p_type,

Line 557: pay_run_types_f prt,

553: from per_time_periods ptp,
554: per_assignment_status_types past,
555: per_assignments_f pa,
556: pay_payroll_actions ppa,
557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,
560: pay_payroll_actions bppa,
561: pay_assignment_actions bpaa

Line 574: from pay_run_types_f prt2

570: 'ALR','BON_ALR',
571: 'MTH')
572: and not exists(
573: select null
574: from pay_run_types_f prt2
575: where prt2.run_type_id = prt.run_type_id
576: and prt2.effective_start_date = prt.effective_start_date
577: and prt2.effective_end_date = prt.effective_end_date
578: and prt2.run_type_name = decode(l_type,