DBA Data[Home] [Help]

APPS.PAY_KR_MAGTAPE_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 6: cursor csr_header(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))) is

2: /* $Header: pykrmgtp.pkh 115.5 2003/05/30 07:38:17 nnaresh ship $ */
3: --
4: level_cnt number;
5: --
6: cursor csr_header(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))) is
7: select
8: 'BUSINESS_GROUP_ID=C', to_char(ppa2.business_group_id),
9: 'PAYROLL_ID=C', to_char(ppa2.payroll_id),
10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),

Line 53: p_payroll_action_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),

49: hrl.meaning,
50: opmtl.org_payment_method_name;
51: --
52: cursor csr_data(
53: p_payroll_action_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
54: p_org_payment_method_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('ORG_PAY_METHOD_ID')),
55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
56: select
57: 'LAST_NAME=P', pp.last_name,

Line 54: p_org_payment_method_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('ORG_PAY_METHOD_ID')),

50: opmtl.org_payment_method_name;
51: --
52: cursor csr_data(
53: p_payroll_action_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
54: p_org_payment_method_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('ORG_PAY_METHOD_ID')),
55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
56: select
57: 'LAST_NAME=P', pp.last_name,
58: 'FIRST_NAME=P', pp.first_name,

Line 55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is

51: --
52: cursor csr_data(
53: p_payroll_action_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
54: p_org_payment_method_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('ORG_PAY_METHOD_ID')),
55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
56: select
57: 'LAST_NAME=P', pp.last_name,
58: 'FIRST_NAME=P', pp.first_name,
59: 'NATIONAL_IDENTIFIER=P', nvl(pp.national_identifier, ' '),