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.

[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_PRE_PAYMENTS

Line 28: (pre_payment_id pay_pre_payments.pre_payment_id%type,

24: a_action_id number
25: );
26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,

Line 29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,

25: );
26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,

Line 30: assignment_action_id pay_pre_payments.assignment_action_id%type,

26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,

Line 31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,

27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,

Line 32: value pay_pre_payments.value%type,

28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,

Line 33: base_currency_value pay_pre_payments.base_currency_value%type,

29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,

Line 34: source_action_id pay_pre_payments.source_action_id%type,

30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,

Line 35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,

31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,

Line 36: organization_id pay_pre_payments.organization_id%type,

32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),

Line 37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,

33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),
41: payment_currency varchar2(16),

Line 38: effective_date pay_pre_payments.effective_date%type,

34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),
41: payment_currency varchar2(16),
42: base_currency varchar2(16)

Line 438: select pay_pre_payments_s.nextval

434: --
435: if (g_pre_payments(cnt).value <> 0
436: or g_pre_payments(cnt).category = 'MT') then
437: --
438: select pay_pre_payments_s.nextval
439: into payment_id
440: from dual;
441: --
442: g_pre_payments(cnt).pre_payment_id := payment_id;

Line 444: insert into pay_pre_payments

440: from dual;
441: --
442: g_pre_payments(cnt).pre_payment_id := payment_id;
443: --
444: insert into pay_pre_payments
445: (pre_payment_id,
446: personal_payment_method_id,
447: org_payment_method_id,
448: value,

Line 809: insert into pay_pre_payments

805: --
806: -- insert a prenote entry.
807: --
808: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',2);
809: insert into pay_pre_payments
810: (pre_payment_id,
811: personal_payment_method_id,
812: org_payment_method_id,
813: value,

Line 819: values (pay_pre_payments_s.nextval,

815: assignment_action_id,
816: organization_id,
817: payees_org_payment_method_id,
818: effective_date)
819: values (pay_pre_payments_s.nextval,
820: personal_method,
821: org_method,
822: validation_value,
823: 0,

Line 3419: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type

3415: --
3416: procedure process_asg_rollup(p_assignment_action in number)
3417: is
3418: --
3419: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3420: index by binary_integer;
3421: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3422: index by binary_integer;
3423: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type

Line 3421: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type

3417: is
3418: --
3419: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3420: index by binary_integer;
3421: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3422: index by binary_integer;
3423: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
3424: index by binary_integer;
3425: --

Line 3442: pay_pre_payments ppp

3438: pay_payroll_actions ppa_pre,
3439: pay_assignment_actions paa_pru,
3440: pay_assignment_actions paa_pre,
3441: pay_action_interlocks pai,
3442: pay_pre_payments ppp
3443: where
3444: paa_pru.assignment_action_id = p_asg_act
3445: and ppa_pru.payroll_action_id = paa_pru.payroll_action_id
3446: and paa_pru.assignment_action_id = pai.locking_action_id

Line 3500: pay_pre_payments ppp

3496: ppp.organization_id,
3497: sum(nvl(base_currency_value, 0)) base_currency_value,
3498: sum(nvl(value,0)) value
3499: from pay_contributing_payments pcp,
3500: pay_pre_payments ppp
3501: where pcp.payroll_action_id = p_pactid
3502: and pcp.contributing_pre_payment_id = ppp.pre_payment_id
3503: group by ppp.org_payment_method_id,
3504: ppp.payees_org_payment_method_id,

Line 3507: l_pre_pay_id pay_pre_payments.pre_payment_id%type;

3503: group by ppp.org_payment_method_id,
3504: ppp.payees_org_payment_method_id,
3505: ppp.organization_id;
3506: --
3507: l_pre_pay_id pay_pre_payments.pre_payment_id%type;
3508: --
3509: begin
3510: --
3511: for totrec in get_totals(p_pactid) loop

Line 3513: select pay_pre_payments_s.nextval

3509: begin
3510: --
3511: for totrec in get_totals(p_pactid) loop
3512: --
3513: select pay_pre_payments_s.nextval
3514: into l_pre_pay_id
3515: from dual;
3516: --
3517: insert into pay_pre_payments

Line 3517: insert into pay_pre_payments

3513: select pay_pre_payments_s.nextval
3514: into l_pre_pay_id
3515: from dual;
3516: --
3517: insert into pay_pre_payments
3518: (pre_payment_id,
3519: org_payment_method_id,
3520: value,
3521: base_currency_value,

Line 3538: from pay_pre_payments ppp

3534: update pay_contributing_payments pcp
3535: set pre_payment_id = l_pre_pay_id
3536: where pcp.payroll_action_id = p_pactid
3537: and exists (select ''
3538: from pay_pre_payments ppp
3539: where ppp.pre_payment_id = pcp.contributing_pre_payment_id
3540: and ppp.org_payment_method_id = totrec.org_payment_method_id
3541: and ppp.payees_org_payment_method_id = totrec.payees_org_payment_method_id
3542: and ppp.organization_id = totrec.organization_id